A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Repeating gradient for each vertical area of plot area



 
 
Thread Tools Display Modes
  #1  
Old October 23rd, 2009, 08:43 PM posted to microsoft.public.excel.charting
Steve Vincent
external usenet poster
 
Posts: 97
Default Repeating gradient for each vertical area of plot area

I have Excel 2007. A colleague saw a line chart with vertical lines in the
plot area, and each resulting rectangular area in the plot area had its own
gradient fill. Each vertical rectangle/gradient was identical. He is asking
me if this is do-able in Excel.

I have been looking into plot area gradients in 2007, and so far I haven't
found a way to apply a gradient fill for each major vertical line rectangle
of the plot area.

Chart type is 2D line chart with primary vertical major gridlines. Do I
need to look at a different chart type in order to accomplish this? I can't
believe that the creator would have gone to the trouble of inserting
individual rectangles with gradients into each of the vertical plot
rectangles.

TIA,
Steve
  #2  
Old October 24th, 2009, 11:06 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Repeating gradient for each vertical area of plot area

Hi,

You can use a dummy series, plotted as column chart type, to mimic the
look. You will need to fix the maximum Y axis value in order to get the
columns to reach the top of the plot area. Set the column series values
to be the same as the max value.
You can then select the series and change the Gap Width to zero.
Now select the first column and format the gradient fill. Repeat
formatting for each individual point in the series.

Cheers
Andy

Steve Vincent wrote:
I have Excel 2007. A colleague saw a line chart with vertical lines in the
plot area, and each resulting rectangular area in the plot area had its own
gradient fill. Each vertical rectangle/gradient was identical. He is asking
me if this is do-able in Excel.

I have been looking into plot area gradients in 2007, and so far I haven't
found a way to apply a gradient fill for each major vertical line rectangle
of the plot area.

Chart type is 2D line chart with primary vertical major gridlines. Do I
need to look at a different chart type in order to accomplish this? I can't
believe that the creator would have gone to the trouble of inserting
individual rectangles with gradients into each of the vertical plot
rectangles.

TIA,
Steve


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3  
Old October 28th, 2009, 12:16 AM posted to microsoft.public.excel.charting
Steve Vincent
external usenet poster
 
Posts: 97
Default Repeating gradient for each vertical area of plot area

Andy,

Thank you for the tip. I thought about doing that, but didn't because I
wasn't coming up with how to show a line chart over the top of the bar chart?
I did creat a dummy chart and formatted each bar with a gradient, with zero
gap. It definitely has the look I'm going for. But now... what about the
actual line chart with the real data line and points? How can I make that
overlay the faux bar chart?

TIA, again,
Steve


"Andy Pope" wrote:

Hi,

You can use a dummy series, plotted as column chart type, to mimic the
look. You will need to fix the maximum Y axis value in order to get the
columns to reach the top of the plot area. Set the column series values
to be the same as the max value.
You can then select the series and change the Gap Width to zero.
Now select the first column and format the gradient fill. Repeat
formatting for each individual point in the series.

Cheers
Andy

Steve Vincent wrote:
I have Excel 2007. A colleague saw a line chart with vertical lines in the
plot area, and each resulting rectangular area in the plot area had its own
gradient fill. Each vertical rectangle/gradient was identical. He is asking
me if this is do-able in Excel.

I have been looking into plot area gradients in 2007, and so far I haven't
found a way to apply a gradient fill for each major vertical line rectangle
of the plot area.

Chart type is 2D line chart with primary vertical major gridlines. Do I
need to look at a different chart type in order to accomplish this? I can't
believe that the creator would have gone to the trouble of inserting
individual rectangles with gradients into each of the vertical plot
rectangles.

TIA,
Steve


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.

  #4  
Old October 28th, 2009, 12:25 AM posted to microsoft.public.excel.charting
Steve Vincent
external usenet poster
 
Posts: 97
Default Repeating gradient for each vertical area of plot area

Found my own answer -- create it as a clustered column chart, then change the
"real" data series to line chart with markers.

Thanks again Andy, your advice led me down the right path!

Steve

"Steve Vincent" wrote:

Andy,

Thank you for the tip. I thought about doing that, but didn't because I
wasn't coming up with how to show a line chart over the top of the bar chart?
I did creat a dummy chart and formatted each bar with a gradient, with zero
gap. It definitely has the look I'm going for. But now... what about the
actual line chart with the real data line and points? How can I make that
overlay the faux bar chart?

TIA, again,
Steve


"Andy Pope" wrote:

Hi,

You can use a dummy series, plotted as column chart type, to mimic the
look. You will need to fix the maximum Y axis value in order to get the
columns to reach the top of the plot area. Set the column series values
to be the same as the max value.
You can then select the series and change the Gap Width to zero.
Now select the first column and format the gradient fill. Repeat
formatting for each individual point in the series.

Cheers
Andy

Steve Vincent wrote:
I have Excel 2007. A colleague saw a line chart with vertical lines in the
plot area, and each resulting rectangular area in the plot area had its own
gradient fill. Each vertical rectangle/gradient was identical. He is asking
me if this is do-able in Excel.

I have been looking into plot area gradients in 2007, and so far I haven't
found a way to apply a gradient fill for each major vertical line rectangle
of the plot area.

Chart type is 2D line chart with primary vertical major gridlines. Do I
need to look at a different chart type in order to accomplish this? I can't
believe that the creator would have gone to the trouble of inserting
individual rectangles with gradients into each of the vertical plot
rectangles.

TIA,
Steve


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.