How do I Chart a spreadsheet that has multiple columns of data
 

I have a spreadsheet that has multiple columns of data. What I have been
asked to do is take the 6 categories and get the actual and standard data in
a chart.

Any help would be most apprciated.
--
DMM

How do I Chart a spreadsheet that has multiple columns of data
 

Did you try selecting the data and running the chart wizard?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a spreadsheet that has multiple columns of data. What I have been
asked to do is take the 6 categories and get the actual and standard data
in
a chart.

Any help would be most apprciated.
--
DMM

How do I Chart a spreadsheet that has multiple columns of data
 

Hi Jon,

I did do that, but the data is spread over almost 20 columns it's creating a
chart that can't be read.
--
DMM


"Jon Peltier" wrote:

Did you try selecting the data and running the chart wizard?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a spreadsheet that has multiple columns of data. What I have been
asked to do is take the 6 categories and get the actual and standard data
in
a chart.

Any help would be most apprciated.
--
DMM

How do I Chart a spreadsheet that has multiple columns of data
 

Are there 20 distinct series of data, or can you consolidate it efficiently
and correctly into fewer columns?

Remember, the purpose of a chart isn't to include every data point you have,
but to clearly convey the information inherent in the data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
Hi Jon,

I did do that, but the data is spread over almost 20 columns it's creating
a
chart that can't be read.
--
DMM


"Jon Peltier" wrote:

Did you try selecting the data and running the chart wizard?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"soconfused" wrote in message
...
I have a spreadsheet that has multiple columns of data. What I have
been
asked to do is take the 6 categories and get the actual and standard
data
in
a chart.

Any help would be most apprciated.
--
DMM