Please help. We are trying to create a stacked bar graph with an average line. Each time we try to add in the average data to the graph it adds it to the stacked bar. The stacked bar should represent the inpatient & outpatient cases at a hospital for the current year (months showing across the as columns). The line should represent the previous 2-yr average total. Anyone have an idea how to add a line to the stacked bar graph? It has us stumped. Thanks!
Last edited by VBA Noob; 04-02-2009 at 02:17 PM.
Add your average data (allow it to be added to the stack). Right click on the data series for the average line and choose Chart Type.... Choose the line type you want to use and format accordingly.
I neglected to mention that you need to create the stacked portion first then add the average line a a second data series.
Worked perfectly!! Thanks for letting us know the secret.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks