ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chart Question (https://www.excelbanter.com/excel-discussion-misc-queries/233799-chart-question.html)

dhstein

Chart Question
 
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.



Jacob Skaria

Chart Question
 
1. Click on the bar. From menu HomeFill Color..
2. You can either just place a text box or can use a chart labeler add-in.

http://www.appspro.com/Utilities/ChartLabeler.htm

If this post helps click Yes
---------------
Jacob Skaria


"dhstein" wrote:

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.



RidgeView

Chart Question
 


"dhstein" wrote:

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:

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.....

Shane Devenshire[_2_]

Chart Question
 
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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dhstein" wrote:

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.




All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com