Hi,
I have a challenge. I am doing a line chart which plots different prices, for example: $1, 2, 2.99, 3, 3.99 etc. As you can see, they are unequal amounts. Is there a way that I can have the axis where only the prices are 1, 2, 3 show up as values and yet they are equally spread out, and still be able to plot 1, 2, 2.99 etc.?
Results 1 to 2 of 2
-
Lounger
- Join Date
- May 2001
- Posts
- 31
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-01-22 18:18Price point line chart (Excel 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
WS Lounge VIP
- Join Date
- Jul 2002
- Location
- Pittsburgh, Pennsylvania, USA
- Posts
- 10,196
- Thanks
- 8
- Thanked 165 Times in 160 Posts
2003-01-22 18:53Re: Price point line chart (Excel 2000)
Use an XY scatter chart NOT a line.
In XY scatter X-axis is a value, in a line (and all other types) the Xaxis is only a category.
Steve
