pivot charts in excel changing layout

E

etaf

I have been putting together some pivot table charts in excel (for m
brother who has excel2000, I have excel2003 - both versions show th
same problem).
the charts default to a bar chart.
I have set up a custom chart which has 1 bar and 1 line - i have als
set it to default.
However, every time the chart is updated or change - ot changes back t
the barchart only.

so say we have 5 periods of data and on the chart we look at period 1
with a bar/line combo with clear background graph, when we change t
period 2 on the pivot the chart changes to just a barchart with a gra
background.

how can i set our custome chart to stay default.....

thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top