Best Microsoft Excel Bloggers

Wednesday, December 15, 2010

When your X axis are numbers

You get to be my guineau pigs. I played around and created some Excel videos about a year ago and put a few on YouTube and then I just never got back to it.  However, I am finishing up a self-study CPE course on Excel Charting and thought that perhaps creating a selfstudy video course would be a nice course since charting is so visual. So, anyway, this is my first crack at it. 

In the video, I talk about the problems of charting when your X axis are numbers instead of text. As you can see from the screenshot below, the chart has a few problems and does not display the selected data in Column A and B very well. To see how to solve the problem, click on the video.


When you play the video, click the icon on the far right to get it to full screen mode.
Let me know what you think. If you can't access the video here, check it out on YouTube.

3 comments:

  1. Maybe I missed it, but is there a link to the youtube videos you mentioned - would love to see them. Have numerical values on the X-Axis (usually without lookups to months, for example) is a common issue we see in excel reporting and dashboards.

    ReplyDelete
  2. Hi John- I only have a couple of videos out there but I will be adding more shortly. I hope you enjoy them.
    http://www.youtube.com/user/cpaselfstudy

    ReplyDelete
  3. I didn't see the video, but I suspect the problems with numerical X-axis data can be solved by using a chart type that treats X values as numbers. In other words, use an XY chart to plot this data.

    ReplyDelete


Ms. Excel- Resident Excel Geek