Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Gradient fill Plot Area in Excel 2007
I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a
gradient fill to the plot area of a chart by selecting my own colours. 2007 just seems to offer a number of preset colours. Does anyone know if it is possible to apply your own clours to gradient fill in 2007? Many thanks, Geoff |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Gradient fill Plot Area in Excel 2007
Microsoft removed this feature; maybe someone read Tufte's book?
However, Andy has given us a very useful macro to make patterns. Visit http://www.andypope.info/charts/patternfills.htm It is very easy to install and use. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Geoff Budd" wrote in message ... I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a gradient fill to the plot area of a chart by selecting my own colours. 2007 just seems to offer a number of preset colours. Does anyone know if it is possible to apply your own clours to gradient fill in 2007? Many thanks, Geoff |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Gradient fill Plot Area in Excel 2007
Hi,
If you are talking about gradient fills rather than the Pattern fills Bernard mentions then you can use your own colours via the controls below the Pre defined gradients. You set the number of stops and the colour to use at each. This is for smart art but the approach should be the same http://office.microsoft.com/en-gb/ex...365991033.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Geoff Budd" wrote in message ... I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a gradient fill to the plot area of a chart by selecting my own colours. 2007 just seems to offer a number of preset colours. Does anyone know if it is possible to apply your own clours to gradient fill in 2007? Many thanks, Geoff |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Gradient fill Plot Area in Excel 2007
maybe someone read Tufte's book?
Sure they read it. Did they apply any of it? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bernard Liengme" wrote in message ... Microsoft removed this feature; maybe someone read Tufte's book? However, Andy has given us a very useful macro to make patterns. Visit http://www.andypope.info/charts/patternfills.htm It is very easy to install and use. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Geoff Budd" wrote in message ... I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a gradient fill to the plot area of a chart by selecting my own colours. 2007 just seems to offer a number of preset colours. Does anyone know if it is possible to apply your own clours to gradient fill in 2007? Many thanks, Geoff |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts - Gradient fill Plot Area in Excel 2007
Thanks Andy. The "stops" seem to be the answer. I obviously had not
experimented enough! Geoff "Andy Pope" wrote: Hi, If you are talking about gradient fills rather than the Pattern fills Bernard mentions then you can use your own colours via the controls below the Pre defined gradients. You set the number of stops and the colour to use at each. This is for smart art but the approach should be the same http://office.microsoft.com/en-gb/ex...365991033.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Geoff Budd" wrote in message ... I have just upgraded from Excel 2003 to Excel 2007. In 2003, I could apply a gradient fill to the plot area of a chart by selecting my own colours. 2007 just seems to offer a number of preset colours. Does anyone know if it is possible to apply your own clours to gradient fill in 2007? Many thanks, Geoff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeating colors in excel 2007 area charts | Charts and Charting in Excel | |||
Plot area of embedded charts unexplainably shrinks in Excel 2003 S | Charts and Charting in Excel | |||
Plot Area Changes in Charts | Charts and Charting in Excel | |||
Plot Area Fill Cut Off When Printed | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel |