Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Formating
I have a chart that has 6 bars of data within it and it has 3 different types
of colours for 3 of the 6 bars. I then want to copy this formating (all in the same place within the chart) in one hit to numerous other charts in one of my sheets. My sheet can contain up to 6 charts and it is too long winded individually clicking on one bar at a time and choosing the colour and pattern etc.. Please help? I have tried the format painter but it is greyed out when you are active in the chart so this does not work? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Formating
Copy the first chart, select the second chart, use Paste Special, and choose
the Formats option. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sandypants" wrote in message ... I have a chart that has 6 bars of data within it and it has 3 different types of colours for 3 of the 6 bars. I then want to copy this formating (all in the same place within the chart) in one hit to numerous other charts in one of my sheets. My sheet can contain up to 6 charts and it is too long winded individually clicking on one bar at a time and choosing the colour and pattern etc.. Please help? I have tried the format painter but it is greyed out when you are active in the chart so this does not work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Formating | Excel Worksheet Functions | |||
2007 Chart formating | Excel Discussion (Misc queries) | |||
Formating textbox on a chart | Charts and Charting in Excel | |||
Conditional chart formating | Charts and Charting in Excel | |||
Chart formating problem | Charts and Charting in Excel |