Graphing Trouble

  • Thread starter ¤Xperimental¤
  • Start date
¤

¤Xperimental¤

Greetings,

I am having some trouble plotting the following data;

September December
Apples 315 137
Watermelon 34 34
Grapes 2015 5717
Pears 92 101
Oranges 545 213
Kiwifruit 742 359
Pineapples 82 230


I trying to plot the grapes in their own series with their own scale but I
am stuck.

If anyone could help me by pointing me in the right direction, I would
greatly appreciate it.

Thanks.
 
A

Andy Pope

Hi,

Assuming your data is in the range A1:C8, select the range and start the
chart wizard.
Select the appropriate line chart style and change the plot of series to
be by rows. This will make each fruit a data series.
To make grapes appear on its own scale double click the series and on
the Axis tab select secondary.

Cheers
Andy
 
Top