Chart Question

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

In a bar chart I can't find how to change the colors of the bars. Also I'd
like to put a label at the bottom of the chart. This is Excel 2007. Thanks
for any help on this.
 
dhstein said:
In a bar chart I can't find how to change the colors of the bars. Also I'd
like to put a label at the bottom of the chart. This is Excel 2007. Thanks
for any help on this.

A. Bar Colors:
Click to expand...
1. Highlight the bars in your graph by clicking on one of them.
2. At the top of your worksheet select "Home/Font/Fill Color". 3. As you
run your mouse over the colors, the bars will change accordingly. 4. Stop
at the desired color.
B. Chart Label at bottom of graph:
1. Under the title "CHART TOOLS", select the tab "Layout/Axis
Title/Primary Horizontal Axis Title/Title Below Axis". 2. Change the
prompted area to what ever you call it.
REGARDS.....
 
Hi,

1. Right-click the bar and choose Format Data Series, Fill tab, ...
for solid colors pick Solid fill or try the other goodies.
2. Choose Insert, Text Box click where you want the text box and start typing.
 
Back
Top