| Home |
| Search |
| Today's Posts |
|
#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? |
| 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 | |||
Threaded Mode
