Graphing Trouble
 

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.

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

¤Xperimental¤ wrote:
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.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info