Excel 2003 Line Chart

User avatar
DaveInPitt
StarLounger
Posts: 82
Joined: 17 Feb 2010, 20:26
Location: Pittsburgh, PA

Excel 2003 Line Chart

Post by DaveInPitt »

I'm trying to create what I believe is a basic line chart. My X axis is Year and my Y axis are Amounts. The wizard is not automatically picking up the correct data for my axis(s). After I create the line chart do I need to manually format the axis data? Here's an example of my axis data and the line chart after the chart wizard creates it. As you can see in the completed line chart my axis data is different than what I had selected in my spreadsheet. Thanks in advance for any suggestions.

:flee:
You do not have the required permissions to view the files attached to this post.
DaveInPitt
Pittsburgh, PA

User avatar
StuartR
Administrator
Posts: 12604
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Excel 2003 Line Chart

Post by StuartR »

Right click on the horizontal axis, choose format axis.
Select the scale tab, set minimum = 2001, maximum =2009, major unit=1
Select the alignment tab, set text to 90 Degrees
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
mbarron
2StarLounger
Posts: 112
Joined: 25 Jan 2010, 20:19

Re: Excel 2003 Line Chart

Post by mbarron »

What do you mean by "it's different"? The years are being shown as every two, and your amounts are being shown as every 50,000.