![]() |
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. |
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. |
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..... |
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