Hello,
I've got a basic column chart with vertical grid lines but no horizontal grid lines. On my category axis I have week ending dates. All I want to be able to do is stagger the background color between each day (between each major grid line) so that they alternate between gray and white (e.g. 1/8/11 white, 1/15/11 gray, 1/22/11 gray, etc.). I'm sure there has to be a fairly simple way to do this but I haven't been able to find it. Any ideas?
Thanks!
Hello,
you can create a column chart with the same number of values on the x axis as the other data series. The values alternate between 1 and 0. Create a column chart with that data. Add your other data series to the chart and send them to the secondary axis.
Now the first data series is in the background. Set its Y axis to maximum of 1, set the series to have no gap and there is your banded background.
Since the main data is on the secondary axis, you need to format the secondary Y axis to cross at the minimum date.
see attached.
For more ideas about color banding chart backgrounds, see http://peltiertech.com/Excel/Charts/BackgroundFill.html
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks