| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying PivotChart Formatting Excel 2007
So here's a new 'feature' for 2007 that I can't quite figure out. Basically,
I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Copying PivotChart Formatting Excel 2007
Hi Eric,
1. Paste Special was not available in 2003 for PivotCharts or in 2007. 2. Maybe the best solution is to create a chart template and then apply that to future charts. The copy and paste format command works for regular charts but not pivot charts in both versions of Excel. -- Cheers, Shane Devenshire "Eric" wrote: So here's a new 'feature' for 2007 that I can't quite figure out. Basically, I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Copying PivotChart Formatting Excel 2007
Ahh, I see.
Can chart templates be created for PivotCharts? If so, how? I don't see the option anywhere. Thanks! Eric "ShaneDevenshire" wrote: Hi Eric, 1. Paste Special was not available in 2003 for PivotCharts or in 2007. 2. Maybe the best solution is to create a chart template and then apply that to future charts. The copy and paste format command works for regular charts but not pivot charts in both versions of Excel. -- Cheers, Shane Devenshire "Eric" wrote: So here's a new 'feature' for 2007 that I can't quite figure out. Basically, I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Copying PivotChart Formatting Excel 2007
Hi Eric,
1. Select the pivot chart 2. Choose PivotChart Tools, Design, Save As Template (in the Type group) 3. give it a name and you're done. -- Cheers, Shane Devenshire "Eric" wrote: Ahh, I see. Can chart templates be created for PivotCharts? If so, how? I don't see the option anywhere. Thanks! Eric "ShaneDevenshire" wrote: Hi Eric, 1. Paste Special was not available in 2003 for PivotCharts or in 2007. 2. Maybe the best solution is to create a chart template and then apply that to future charts. The copy and paste format command works for regular charts but not pivot charts in both versions of Excel. -- Cheers, Shane Devenshire "Eric" wrote: So here's a new 'feature' for 2007 that I can't quite figure out. Basically, I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Copying PivotChart Formatting Excel 2007
Thank you! However, this doesn't just save the formatting, it also saves the
metrics used in the chart. Is there anyway to just save the formatting; the colors, styles, and chart type? Thanks again, Eric "ShaneDevenshire" wrote: Hi Eric, 1. Select the pivot chart 2. Choose PivotChart Tools, Design, Save As Template (in the Type group) 3. give it a name and you're done. -- Cheers, Shane Devenshire "Eric" wrote: Ahh, I see. Can chart templates be created for PivotCharts? If so, how? I don't see the option anywhere. Thanks! Eric "ShaneDevenshire" wrote: Hi Eric, 1. Paste Special was not available in 2003 for PivotCharts or in 2007. 2. Maybe the best solution is to create a chart template and then apply that to future charts. The copy and paste format command works for regular charts but not pivot charts in both versions of Excel. -- Cheers, Shane Devenshire "Eric" wrote: So here's a new 'feature' for 2007 that I can't quite figure out. Basically, I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Copying PivotChart Formatting Excel 2007
Hi Eric,
Sorry to take so long getting back but yeasterday was a very long workday. I can't duplicate your problem. When I create a chart template from a pivot chart and then select another pivot table and launch the Create Chart dialog box and pick template folder and then the pivot table template, the chart that results is formatted as the original pivot chart and the data is the new data? -- Cheers, Shane Devenshire "Eric" wrote: Thank you! However, this doesn't just save the formatting, it also saves the metrics used in the chart. Is there anyway to just save the formatting; the colors, styles, and chart type? Thanks again, Eric "ShaneDevenshire" wrote: Hi Eric, 1. Select the pivot chart 2. Choose PivotChart Tools, Design, Save As Template (in the Type group) 3. give it a name and you're done. -- Cheers, Shane Devenshire "Eric" wrote: Ahh, I see. Can chart templates be created for PivotCharts? If so, how? I don't see the option anywhere. Thanks! Eric "ShaneDevenshire" wrote: Hi Eric, 1. Paste Special was not available in 2003 for PivotCharts or in 2007. 2. Maybe the best solution is to create a chart template and then apply that to future charts. The copy and paste format command works for regular charts but not pivot charts in both versions of Excel. -- Cheers, Shane Devenshire "Eric" wrote: So here's a new 'feature' for 2007 that I can't quite figure out. Basically, I have 2 graphs. One is nicely formatted, the other, not at all. I'd like to simply copy the formatting of one and paste it to the other, but cannot figure out how to do this. In past versions of Excel, I thought that I'd have been able to choose Paste Special, then Format, but Paste Special doesn't work when I click on PivotCharts. Any ideas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make pivotchart formatting stick after pivottable refresh. | Charts and Charting in Excel | |||
| save pivotchart formatting - colors etc.... | Charts and Charting in Excel | |||
| Preserving PivotChart Formatting | New Users to Excel | |||
| Excel 2007 - Filtering and copying | Excel Discussion (Misc queries) | |||
| Copying data - Excel 2007 | Excel Worksheet Functions | |||
Linear Mode
