Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
JJ
 
Posts: n/a
Default Background Color Code Sections

I have 7 different major sections (years) on the x axis of a bar graph. Is it
possible to have the backround/plot area (not the bars) colored in 7
different shades? Help is appreciated!
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Background Color Code Sections

Use a set of area chart series on the primary axes, using a technique like
this:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

Then add new series for the bars. When you first add a new series it will
not be the type you want, so change it to the bar or column (or whatever
else) you want. You will probably also want it on the secondary axes.

You can hide the primary axes and rearrange the other axes so the chart
looks like you want it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"JJ" wrote in message
...
I have 7 different major sections (years) on the x axis of a bar graph. Is
it
possible to have the backround/plot area (not the bars) colored in 7
different shades? Help is appreciated!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to apply the same background to many sheets simultaneously. Colin Hayes Excel Worksheet Functions 2 June 11th 05 02:47 PM
Form-filling application with Excel (background image)? J.Smith Excel Discussion (Misc queries) 1 May 15th 05 08:40 AM
establishing the background colour of a cell ac512 Excel Discussion (Misc queries) 4 April 15th 05 08:20 PM
Background Picture OR text over a picture greg Excel Discussion (Misc queries) 1 March 30th 05 12:31 AM
Photo for background takes a lot of space (MB) Charles Ménard Setting up and Configuration of Excel 0 January 7th 05 07:21 PM


All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"