[email protected]

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You can learn a lot by screwing up.

Save your workbook (just in case you really screw up).

Try it one way. If it didn't work, do a bunch of undo's or close without
saving.

Reopen and try the other way.

In fact, when I see step 2 of 4, I get to see how the graph would look.

So I can see if I choose columns--I see east/west/... along the X axis.
(and the quarters in the Legend).

If I choose rows, things are reversed.

So which way did you want to chart your data?
 
Back
Top