Sarathc.com

Personal website & blog of Sarath Chandran - my view, my thoughts

Plot an X, Y Axis/Axes Column or Bar Chart in Excel

Recently my sister asked me to plot a bar chart in excel from a table of data. There were 5 different columns but she only wants to choose 2 columns, one going to X- Axis/Axes or Y-Axis/Axes.

Now initially when I heard about this, I thought ohh, its just a piece of cake.. right because excel is known for its charts and it should be easy. But soon I realized its not..here is why..

Before we start that I should show how my table looks like :


Table To Extract Data For Graph

Table To Extract Data For Graph

Now I have to extract data from Conc column to show as X-Axis and % (percentage) as Y-Axis

By default when you export data from table into charts by going to Insert > Chart and you choose the chart, be it the column or bar chart, it only gives either X axis or Y axis to give the data range. And Excel automatically selects the other axis.

Now this is not what I want, I need to plot both axis. After couple of googling, i found that this cannot be done straight away. I may be wrong but this is how it worked for me…

Go to Insert > Chart and Select from Standard Types select XY (Scatter) go to next button, here it should show Chart Wizard – Step 2 of 4 – Chart Source Data. Here select the 2nd tab that says Series.

Here under series , you will series heading with a small box with Add button, click the Add button which will pop up with these :


wizard-empty

Chart Wizard - Step 2 of 4 - Chart Source Data

Under name you can either type in the name or clicking on the small icon besides will let you select the data range from the excel sheets. You can select X-Axis values by clicking on the icon to select the data range starting from the values (excluding the heading/title) Do the same for Y-Axis values.This can be done by clicking from the top cell down to bottom till the end of the data cell.

Click on next, you should be in Chart Wizard – Step 3 of 4 – Chart Source Data You can give the title for X & Y Axis . Go to legend tab in the same step and I choose to show the legend at the bottom, it sort of gives my graph a better room to show data. You can remove this legend later. Go to next step and click on finish.

Now you should have a Scattered Graph, which is not what we want, therefore, Right Click on the Graph area, which will drop down a menu with some options, select change chart type

Change Chart Type

Change Chart Type

Clicking on chart type will give you the Chart Type window and Select the Bar or Column Chart from this window.

Now you should be able to see bar or column layout of your graph with X & Y Axis plotted. That’s it off you go!!

12 Comments

  1. This is often a fantastic web site which aids me to have a lot more information to the topic. I’m going to bookmark it!

  2. hey i read your web log every the time, you have numerous wonderful things to say. My reviewers would like your flair, do you consider you could be a guest blogger for me?

  3. Thanks helped a lot :-)

  4. Great help!

  5. Hey thanks. Well done

  6. Asking questions are genuinely nice thing if you are not understanding something entirely, however this paragraph gives good understanding even.

  7. Healthy Children

    May 1, 2013 at 12:26 am

    I really like what you guys are usually up too. This sort of clever work and coverage!
    Keep up the excellent works guys I’ve incorporated you guys to my personal blogroll.

  8. Niсе post. I beсаme checking constantly this weblog аnd I’m impressed! Very helpful info specifically the last part :) I take care of such information a good deal. I became seeking this certain info for one very lengthy time. Thanks and good luck.

  9. Jasvir Teotia

    May 6, 2013 at 11:17 am

    If a residential plot of 47ftx18ft is divided into 16 equal parts by drawing lines from the centre of plot making 16 triangles of 11.25 degrees,how can I measure the triangles area of all 16 triangles saparately and show the values of all on a bar chart. Thnx..Jasvir

  10. You’ve got described a very good details , regards in your post.

  11. This does not work on Mac Excel 2010.

    x-y scatter -> column creates a graph with x-axis being filled equally-spaced data points (instead of 1.3…..9, on gets 139) while y-axis data is plotted correctly.

  12. I read a lot of interesting content here. Probably you spend a
    lot of time writing, i know how to save you a lot of time, there
    is an online tool that creates readable, google friendly
    posts in seconds, just search in google – laranitas free
    content source

Leave a Reply

Your email address will not be published.

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© 2014 Sarathc.com

Theme by Anders NorenUp ↑