Q: Formatting Bar Graph...

  • Thread starter Thread starter MarkD
  • Start date Start date
M

MarkD

I have a bar graph that charts 4 regions: east, west,
north, south. Beneath it, I have a data table with the
counts for those regions. I also have the total counts
(sum of the 4 regions).

What I've done is made the bar color for the total counts
to "none" so, basically it doesn't show up on the bar graph
(or rather, is hidden), but it does show up on the data
table.

The problem is, now I have another region added
(California -- CA always has to be different!), and the
bar graph doesn't take that into consideration. Now, the
California region (it being the 5th data element) is blank
and the totals are a new color. And I can't find a way to
select the California data point to change the color. When
I select in the spot the data point should be, it doesn't
allow me to "format the data series".

Do I have to redo the bar graph?

Thanks,
-Mark
 
Hi Mark,

If you can't click the data series then try one of the others and use
the cursor keys (up/down) to move thru the chart elements.

Cheers
Andy
 
Sometimes it's the obvious you miss, isn't it (just say
yes and make me feel less of a dolt).

THANKS SO MUCH for your help! I need to reformat a couple
dozen charts and this makes it much easier.

-Mark
 
Back
Top