Nick has attended:
Access Introduction course
Pivot Chart Report(2)
Hi - I've already posted this question but yet unresolved and I'm need an urgent solution!! - Pete has had a go, is there anyone else who can help??
I am creating a chart from a pivot table (i.e. a pivot chart report) - when I change a variable on the pivot chart the format of the chart changes.
I am not using a standrd chart, I'm using an excel custom type chart (line - column on 2 axes) - when I change a variable on the chart the chart defaults back to a standard chart.
Can you please explain how I can set up a "line - column on 2 axes" chart and when I change a variable to keep this chart format.
If easier to discuss please feel free to call me on 020 7335 7379
Thanks
NICK
RE: Pivot Chart Report(2)
Hi Nick
Happy to help with this - could you send a copy of the file you are working on to forum AT stl-training.co.uk for the attention of Andrew and I'll take a look at the problem.
Kind regards,
Andrew
RE: Pivot Chart Report(2)
Hi Nick
Thanks for the file. I've checked and it appears that this may be related to a problem Microsoft is aware of. Take a look at the following information:
http://support.microsoft.com/?id=215904
for more details and a suggested workaround. Does this resolve your problem?
Kind regards,
Andrew
