Charting table with mixed data

  • Thread starter Thread starter darius
  • Start date Start date
D

darius

Hi

I have a table with data like this, with $amount sold and # of sales

$ # $ # $ #
agent A agent B agent C etc ...
Jan $400 20 $230 10 $872 20
Feb $500 12 $888 40 $100 16
Mar etc...
Apr
etc
....

I want to create two charts, one for $amount sold and one for # of sales.
Unfortunately, because the data is mixed like this, I just can't select
the whole range and click chart. Is there a clever way around this,
short of changing the program that generates this data in the first
place?

Thanks.
 
To make the $# chart, select the first column of data, hold CTRL while you
select the second column, then hold CTRL while you select the fourth column,
then the sixth, etc. Now run the chart wizard.

Then to make the # chart, select the first column of data, hold CTRL while
you select the third column, then hold CTRL while you select the fifth
column, then the seventh, etc. Now run the chart wizard again.

- Jon
 
Thanks. I found what also works is to select the range, then in the
chart wizard, select the Series tab and remove the unwanted columns. A
little more work, but it allows for more control.
 
Back
Top