Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have Excel 2007. I want to have a gradient color for a chart. I go to
Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Do you know about Andy Pope's great add-in?
http://www.andypope.info/charts/patternfills.htm best wsihes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "NonTechie" wrote in message ... I have Excel 2007. I want to have a gradient color for a chart. I go to Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Yes, I got that to put patterns on my charts, especially histograms. I don't
see where it will help me with gradients. Do you know how to solve the problem I described? "Bernard Liengme" wrote: Do you know about Andy Pope's great add-in? http://www.andypope.info/charts/patternfills.htm best wsihes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "NonTechie" wrote in message ... I have Excel 2007. I want to have a gradient color for a chart. I go to Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. . |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
After selecting gradient you need to change the 2 stop colours. Select Stop1 and use the Color: dropdown to change the top half of column. Select Stop2 and use the Color: dropdown to change the bottom half of the column For as single colour gradient you will need to set Stop2 to plotarea colour. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "NonTechie" wrote in message ... I have Excel 2007. I want to have a gradient color for a chart. I go to Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thanks, Andy. By the way, I really appreciate the Pattern Fills Add-In you
developed. I use it a lot. Now, I am still stuck on the gradient. When I do what I think you said, the defalult blue color is still in the middle. I select Stop 1 and choose a color. That fills up the top part of the bar with the original soft blue still in the bottom. Then I select Stop 2 and choose a color. That overwrites the first color at the top, and the soft blue is still in the bottom of the bar. I try different stop positions and that just seems to mix everything up. When I try a single color, I do not find plotarea colour anywhere in the list of colors, as you suggest. I still get a muddled mixture when I try different stop positions. So... I still don't know what to do to produce a gradient of a single color of my choosing or a gradient of two colors of my choosing. Maybe you have another add-in that "restores" Excel 2003 gradients like you did for pattern fill. Thanks in advance for any help. "Andy Pope" wrote: Hi, After selecting gradient you need to change the 2 stop colours. Select Stop1 and use the Color: dropdown to change the top half of column. Select Stop2 and use the Color: dropdown to change the bottom half of the column For as single colour gradient you will need to set Stop2 to plotarea colour. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "NonTechie" wrote in message ... I have Excel 2007. I want to have a gradient color for a chart. I go to Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. . |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
First, glad you like the addin :) Do you have the latest Office service pack installed? SP2. To check use Office button Excel Options Resources. You will not find a 'plotarea' colour. What I meant was use the same colour. By default the colour is white and the default gradient is Blue + White. If you do have SP2 and are still stuck you can me send example file to look at. andy AT andypoe DOT info Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "NonTechie" wrote in message ... Thanks, Andy. By the way, I really appreciate the Pattern Fills Add-In you developed. I use it a lot. Now, I am still stuck on the gradient. When I do what I think you said, the defalult blue color is still in the middle. I select Stop 1 and choose a color. That fills up the top part of the bar with the original soft blue still in the bottom. Then I select Stop 2 and choose a color. That overwrites the first color at the top, and the soft blue is still in the bottom of the bar. I try different stop positions and that just seems to mix everything up. When I try a single color, I do not find plotarea colour anywhere in the list of colors, as you suggest. I still get a muddled mixture when I try different stop positions. So... I still don't know what to do to produce a gradient of a single color of my choosing or a gradient of two colors of my choosing. Maybe you have another add-in that "restores" Excel 2003 gradients like you did for pattern fill. Thanks in advance for any help. "Andy Pope" wrote: Hi, After selecting gradient you need to change the 2 stop colours. Select Stop1 and use the Color: dropdown to change the top half of column. Select Stop2 and use the Color: dropdown to change the bottom half of the column For as single colour gradient you will need to set Stop2 to plotarea colour. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "NonTechie" wrote in message ... I have Excel 2007. I want to have a gradient color for a chart. I go to Format Chart Area and click Gradient fill and get a nice single color blue gradient from light blue to white. I want to have a single color gradient but with a different color. The help menu talks about gradient stops, so I tried that, but when I use them with a different color, the blue is still on part of the chart. I really do not understand the gradient stop business. I just want to have a single color gradient with a color of my choice or a two-color gradient with two colors of my choice. I used to be able to do this with ease with Excel 2003, but can't figure out how to do it with Excel 2007. Any help would be most welcome. . |
#7
![]() |
|||
|
|||
![]()
Sure, I can help you with that! Here's how you can change the gradient color in a chart for Excel 2007:
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
Were non-gradient chart patterns left out of Excel 2007? | Charts and Charting in Excel | |||
Are the non-gradient chart patterns missing from Excel 2007? | Excel Worksheet Functions | |||
color gradient in a worksheet (not a chart), Is it Possible? | Excel Worksheet Functions | |||
how do i calculate a chart gradient in excel? | Charts and Charting in Excel |