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

[soconfused]

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.

 

[Jon Peltier]

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

- Jon

 

[soconfused]

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.

 

[Jon Peltier]

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