Excel Line Charts query

[mhraja]

(Also posted on: http://www.excelforum.com/showthread.php?t=1096637&p=4148413#post4148413)

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

<tbody>
</tbody>

Line Charts give me something like this:

But I would like something like this:

Any suggestions?

Many Thanks,

 

[Takae]

Hi,

Make two lines each.
But Item are like this.

Apr	800	200
Apr	800	200
May	800	200
May	1000	300
Jun	1000	300
Jun	1200	400
Jul	1200	400
Jul	1300	500
Aug	1300	500
Aug	1400	600
Sep	1400	600
Sep	1500	700

<tbody>
</tbody>

Choose scatter diagram　(Straight)
Change X-axis's interval to fixed and 40.
Sorry I don't know English expression.

Hope this helps.

 

[Jon Peltier]

Use dates instead of just month labels. Insert a row before each existing row in your data (the shaded cells in the screenshot below) and use the prior month's values for Items 1 and 2. Make the line chart using this data, make sure the horizontal axis is a Date Axis (not a Text Axis) in the Format Axis dialog, and use a custom number format of "MMM" (without the quotes) for the horizontal axis labels.

 

[mhraja]

Thank you Takae & Jon Peltier, this solves my issue.

Best Regards,