| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
inserting a pattern fill in a chart in excel2007
how do u insert a pattern fill into a chart with the new excel 2007?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
inserting a pattern fill in a chart in excel2007
AFAIK, you can't -- the feature has been "deprecated", as they say.
"~Mandy~" wrote in message ... how do u insert a pattern fill into a chart with the new excel 2007? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
inserting a pattern fill in a chart in excel2007
in the background of the chart or in the data bars/lines?
-- Jeff "~Mandy~" wrote: how do u insert a pattern fill into a chart with the new excel 2007? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
inserting a pattern fill in a chart in excel2007
Hi Mandy,
how do u insert a pattern fill into a chart with the new excel 2007? Try this as a workaround. Select a range of cells Format with a pattern of your choice Copy Select the chart series (or a single column) Paste as Picture Ed Ferrero www.edferrero.com |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
inserting a pattern fill in a chart in excel2007
Hi,
The UI to patterns has gone but a little VBA goes a long way ;) No idea how long this will remain a work around. With ActiveSheet.ChartObjects(1).Chart.SeriesCollection (1).Fill .Patterned Pattern:=msoPatternLargeConfetti .ForeColor.SchemeColor = 17 .BackColor.SchemeColor = 2 End With Cheers Andy ~Mandy~ wrote: how do u insert a pattern fill into a chart with the new excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill Links with a Pattern | Excel Discussion (Misc queries) | |||
| How do you control the color/pattern of a pie chart? | Charts and Charting in Excel | |||
| Creating pattern area under part of an x-y chart | Charts and Charting in Excel | |||
| Referencing a cell in another worksheet then using fill handle to continue pattern | Excel Discussion (Misc queries) | |||
| Pie Chart Color/Pattern | Charts and Charting in Excel | |||
Hybrid Mode
