• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Chart - Pivot Chart

Nicki

Member
Hi Guys, Please could you suggest the best way to show the increase or decrease of dosage (Column E)between June and Nov for Three item in Column D (FALLL, FALLR,FALLB) see attached file. Many Thanks
 

Attachments

Chihiro

Excel Ninja
Is there data for FALLB for Nov?

At any rate, there's limited control over charting option when using Pivot Chart.

Use either line chart.
upload_2017-11-24_9-44-34.png

Or various Column/Bar chart.
upload_2017-11-24_9-46-15.png

upload_2017-11-24_9-47-0.png
 

Nicki

Member
Hi Chihiro,
Thanks for your help. that is right no FALLB for Nov. I just forgot to mention, I need dosage to be shown separately not as a sum any idea please.
 

Chihiro

Excel Ninja
How do you mean? You can't use Best Hosp No. since these don't tie anything together... and are unique in your data...

Also, having that many item in your data would make it cluttered and hard to read.

Can you explain full context of how the data should be presented?

Here's another sample (though this really isn't meaningful way to present data and is misleading).

upload_2017-11-24_10-25-8.png
 

Nicki

Member
You are right it will be messy and hard to read. I will stick to the second and third chart. Many Thanks for your help. Have a good weekend
 
Top