Excel Line Charts query

[mhraja]

(Also posted at: http://www.mrexcel.com/forum/excel-q...rts-query.html)

Hi All, I have a pricing data for my products. I was to see the price trend. I can draw on the Charts using the line charts but it's not giving me exactly what I required.

Taking example of only two models:

Month Item 1 Item 2
Apr 800 400
May 800 400
Jun 700 400
Jul 700 400
Aug 600 300


Line Charts give me something like this:

Chart1.png

But I would like something like this:

Chart2.png

Any suggestions?

Many Thanks,

[protonLeah]

(How to) Attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"