Results 1 to 2 of 2

Stacked bar graph with three-month trending

This is a discussion on Stacked bar graph with three-month trending within the Excel Questions forums, part of the Question Forums category; I am trying to make a chart (currently through "pivotchart") that shows stacked bars over three months per goal. For ...

  1. #1
    New Member
    Join Date
    Jan 2014
    Posts
    3

    Unhappy Stacked bar graph with three-month trending

    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!

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,356

    Default Re: Stacked bar graph with three-month trending

    So you want a cluster for each month, where each cluster has three stacked bars?

    Try Clustered and Stacked Column and Bar Charts.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com