Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Plot Area
I have a line graph with data that corresponds to dates. I want to format the plot area so that the fill color is different depending on the dates. For instance 5/15 - 6/20 fill color light gray. For dates 6/21 - 6/30 fill color peach and for dates 7/1-7/30 fill color blue. I can't seem to figure out if it is possible to do this. If anyone has any ideas I would really appreciate it! Thanks!! :) -- V Rocks ------------------------------------------------------------------------ V Rocks's Profile: http://www.excelforum.com/member.php...o&userid=24127 View this thread: http://www.excelforum.com/showthread...hreadid=377464 |
#2
|
|||
|
|||
Perhaps you can modify the stacked area chart technique in this tutorial:
http://pubs.logicalexpressions.com/P...cle.asp?ID=508 You need three series, one for each color. The values for each are full scale within its time range and zero elsewhere. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ V Rocks wrote: I have a line graph with data that corresponds to dates. I want to format the plot area so that the fill color is different depending on the dates. For instance 5/15 - 6/20 fill color light gray. For dates 6/21 - 6/30 fill color peach and for dates 7/1-7/30 fill color blue. I can't seem to figure out if it is possible to do this. If anyone has any ideas I would really appreciate it! Thanks!! :) |
#3
|
|||
|
|||
John - Thanks for your help! I will give it a try. -Joe -- V Rocks ------------------------------------------------------------------------ V Rocks's Profile: http://www.excelforum.com/member.php...o&userid=24127 View this thread: http://www.excelforum.com/showthread...hreadid=377464 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I alter plot area colour in a chart without a mouse? | Charts and Charting in Excel | |||
How do I change the excel chart default plot area color? | Charts and Charting in Excel | |||
Bar Chart Label Sizes | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |