Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart formatting
Is there a way to shade certain areas of a line graph? I have a simple line
graph extending horizontally from point 1 to 10 on the x-axis. I would like to shade the entire background area of the graph from points 2-4 and points 6-8. Is there a way to make the graph apear that the background is grayed out between these points. Thanks Chris |
#2
|
|||
|
|||
Chris -
This has been sitting here a long time... Make a combo chart. Start by locking the Y axis scale parameters (uncheck the auto boxes). Add a series to your chart which has zero values where you want no shading and <Y axis max where you do want shading. Change the series to a column chart (select just the new series, then go to Chart menu, Chart Type). Double click the new column series, on the Options tab set Gap Width to zero, and on the patterns tab, set borders to none and area fill to the shade you want in your chart background for these regions. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Christopher Anderson wrote: Is there a way to shade certain areas of a line graph? I have a simple line graph extending horizontally from point 1 to 10 on the x-axis. I would like to shade the entire background area of the graph from points 2-4 and points 6-8. Is there a way to make the graph apear that the background is grayed out between these points. Thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart formatting | Charts and Charting in Excel | |||
pivot chart formatting | Charts and Charting in Excel | |||
Problem with Chart Title Formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |