Plotting Graph with two Y Axis to show results over time

[JumpInTheFire83]

Hi there,

I am looking advice on plotting a graph that shows product sales for each product over time;

[TABLE="width: 192"]
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Code
[/TD]
[TD="class: xl68, width: 64"]23rd Nov[/TD]
[TD="class: xl68, width: 64"]30th Nov[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K011[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl66, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K012[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl66, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K013[/TD]
[TD="class: xl66, align: right"]108[/TD]
[TD="class: xl66, align: right"]100
[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K014[/TD]
[TD="class: xl66, align: right"]2[/TD]
[TD="class: xl66, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K015[/TD]
[TD="class: xl66, align: right"]8[/TD]
[TD="class: xl66, align: right"]12[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K016[/TD]
[TD="class: xl66, align: right"]2[/TD]
[TD="class: xl66, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K017[/TD]
[TD="class: xl66, align: right"]20[/TD]
[TD="class: xl66, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]K018[/TD]
[TD="class: xl66, align: right"]10[/TD]
[TD="class: xl66, align: right"]11[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]

[/TD]
[/TR]
</tbody>[/TABLE]
There are 3 coloums in my data above. We have one for the product code, then the dates showing how many products were sold on each date. I would like to plot the date along the x-axis, then have the product code along the left y axis, and the values on the right y axis.

From this I would be able to see quickly any increases or decreases in product sales over a given time.

Can you help?

Thanks

 

[hetfieldkaloo]

Assuming you want to plot a line chart: select the entire data table and inset a line chart. Once you see the legend - right click on either 23rd Nov or 30th Nov and select format data series > plot series on secondary axis.
Finally you can format the chart size shape and axis range for symmetry if require.