sumayyah has attended:
Excel Intermediate course
Graphs from pivot tables
I have created a stacked graph, but would like to show the changes in that stacked graph from i.e. 3 months ago. How can this be done?
RE: graphs from pivot tables
Hi Sumayyah
Thank you for your question regarding the stacked chart.
Sorry for the delay in getting back to you. If you could bear with me for another day or so & we'll endeavour to get an answer to you
Kind Regards,
Nafeesa
Microsoft Office Specialist Trainer
RE: graphs from pivot tables
Hi Nafeesa,
No problem, I've got a few more questions. I've figured out how to get the "% difference" and "% of"part. However, I want to be able to show the graph in currency and then add data labels "% of" in percent. It doesn't seem to let me do this. Any idea of how best to tweak this?
Is there a way to you my stacked graph please? The percentage just doesn't match the axis. :) No idea whats happening.
