• 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.

Bar chart showing planned vs actual volume per month

C

Chets

New Member
Hi All

I have a large number of rows of data each with server name, planned date and actual date. I would like to generate a stacked bar chart that shows total number of servers planned vs actual per month. Any guidances or samples?

Thanks.
 
Would you have some sample data with fake server names set please, that you can upload.
Sounds like a pivot chart can be a way to do it.
Not sure you need a stacked chart if you want to compare actuals versus planned. See on the blog for tutorials on target vs budget charts.

EDIT: attached a free sample
upload_2018-11-23_8-45-10.png
 

Attachments

  • Sample_Chandoo241104.xlsx
    34.1 KB · Views: 9
Last edited:
GraH - Guido said:
Would you have some sample data with fake server names set please, that you can upload.
Sounds like a pivot chart can be a way to do it.
Not sure you need a stacked chart if you want to compare actuals versus planned. See on the blog for tutorials on target vs budget charts.

EDIT: attached a free sample
View attachment 56621
Click to expand...
This is what I am looking for. The actual should count dates that are in the same month as planned date. For example, there are 15 servers with planned date in February and 12 actual dates in Feb. Is possible to show bar chart for Feb as 15 plan and 12 actual?
 
You must log in or register to reply here.
Back
Top