Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2001
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Price point line chart (Excel 2000)

    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.?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •