Comparative Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 08 Nov 2003 02:06 GMT

I am new to making charts with Excel. I want to create a comparative. This chart is to show 2 different groups of values on the same chart for comparason.

Thanks for the help.

Reply to this Message

Jon Peltier - 08 Nov 2003 05:15 GMT

Ron -

The first step is to arrange your data. Put the X values (or category
labels) in column A, starting in cell A2; leave cell A1 blank. Put the
legend label for the first series in cell B1 and the values starting in
B2; put the label for the second series in cell C1 and the data starting
in C2.

Select the range and press the Chart Wizard button or choose Chart from
the Insert menu. Trudge on through the wizard until your chart is complete.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I am new to making charts with Excel. I want to create a comparative. This chart is to show 2 different groups of values on the same chart for comparason.
>
> Thanks for the help.

Reply to this Message