How to Make Changes (Line series and Chart Type) in a Pivotchart

[wec43wec]

I have created a number of pivotcharts (line graphs) on the same file using raw data located on sheet 1.

#1. My question is when I select "Format Data Series" to change the size of the entire line, it will only complete a change for the single selected item (Page selection) and not the lines on the other Pages within the same pivot chart.

The other question I have is (as noted above) I have multiple Pivotcharts on different sheets within the file, but using different values from the raw data which is located on sheet one.

#2 My second question: it seems I can only select one type of Custom Chart Type, and similar to the change wihin the lines on the data series, when selecting Chart Type - Custom Types (Line - Column on 2 Axes as an example) it will only hold or be completed for the single chart type selected (page) and not all for all items (pages)on that pivotchart.

Is there a way to make one selection and expect it to apply to all items entered on "Pages" in the Pivot Table and Pivot Chart Wizard - Layout.

Please advise.

Thanks !

 

[SkipVought]

hi,

What version of Excel, please?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[wec43wec]

I think it is 2003.