data series in rows or columns.

[Guest]

I am having problems in a class here which the teacher can't seem to help
with. I was making a bar graph, and the A column had East, West, North, and
South. The one row had 1st Qtr, 2nd Qtr, 3rd Qtr, 4th Qtr. The bars
represent the data. In Chart Wizard, Step 2 of 4, chart source data, there
are two check boxes marked, "series in:" and the boxes are marked "rows" and
"columns". Here's where I get lost. Which way do you read the data?

 

[JulieD]

Hi Mike

"rows" uses the headings across the row as the labels for the X axis and
graphs the data accordingly - i.e. you'ld see the QTRs down the bottom and
each column (line whatever) represents a different location.

"columns" uses the headings down the column as the X axis labels, and each
qtr would be represented as a series on the chart.

Hope this helps
Cheers
JulieD

 

[Myrna Larson]

Try it both ways and see which one gives you the layout you want.