Stacked bar graph with three-month trending

uguadarr

New Member
Joined
Jan 21, 2014
Messages
3
I am trying to make a chart (currently through "pivotchart") that shows stacked bars over three months per goal. For example, one of our doctors has a goal for flu shots, chlamydia screenings, and LDL screenings. So, I want to be able to show how he did over the last three months on every goal. Each bar would be stacked (with successful screenings and failed screenings). In this case, he would have three stacked bars (one for every month) for every goal.

Recap:
3 side-by-side bars per month (last three months) for every goal (three goals for this doctor).
Each bar is stacked with successful and unsuccessful screenings.

Please let me know if you can help!
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,099,092
Messages
5,466,583
Members
406,490
Latest member
Ankusharma

This Week's Hot Topics

Top