Stacked Bar & Line Graph

Sep 20, 2006

how to create a stacked bar & line graph together.

I know by default, I can choose to have a stacked bar, OR a line graph, OR a basic bar & line graph.

But I need to take a step further and have a stacked bar WITH a line graph.

options in which I could combine the above graphs?

View 4 Replies


Stacked Bar Graph With Average Line

Mar 24, 2009

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.

View 3 Replies View Related

Stacked Column & Line In Same Graph

May 28, 2007

I would like to make a graph in Excel, where I present both a stacked column and a line with two different axes. Including a clustered column and a line in the same graph with two different axes is easy, as this combination can be found in the custom types selection in the chart wizard. However, there is no such alternative as a stacked column and a line with two different axes. Is combining the two manually possible?

View 2 Replies View Related

Excel 2010 :: Combining 100% Stacked Column With 100% Stacked Line Using 2 Groups Of Data?

Apr 24, 2014

I am trying to create a 100% stacked column which has a superimposed line chart over the top of it.

Basically % of yes and no for two separate datasets, but which share the same characteristics. The x-axis is months of the year.

All Yes
All No



I can create 2 separate charts. One for the yes/no of one set as a 100% stacked column. I then use 'no fill' on the No column to stop this from being seen.

I can create a 100% line chart for the second data type, and 'no fill' the 100% line that appears.

However, I can't merge the two charts to show the Yes % for one dataset as bars and the Yes % of the other as a line.

I am using Excel 2010 on XP.

View 2 Replies View Related

Line Graph: (line Graph To Display An Amount Over Time)

Dec 30, 2008

I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.

A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:

Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):

Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).

View 2 Replies View Related

Stacked Graph Of Dates

Feb 9, 2014

I wish to plot a Stacked column graph of dates work is completed. Several peoples names along the bottom and dates up the side. The stack shall be broken into 6 steps, each step denoted by the date it was completed.

I would also like a marker at the top of each stack indicating the deadline date.

I'm working from a large table of dates.

View 1 Replies View Related

How To Add (2) New Lines To Stacked Bar Cluster Graph

Jan 31, 2013

So on a primary 'y' axis against I have plotted some stacked clusters (3 categories, each with 2 columns and 2 stacks) and now I want to add a percentage line on a secondary 'y' axis to show the % rates for each category.

How do I plot them? I don't want to use Jon Peltiers utility, as I already have it, but still don't know how to use it to achieve the view.

View 1 Replies View Related

Create Stacked Bar Chart/Graph

May 29, 2008

I need to plot a stacked chart. I have attached a sample of it. I need to plot, category As X and subcategory and and its percentage as Y (stacked chart). In the attached sample I plotted a chart. The problem is, the series name showing is not correct. It takes the series name from the top row.

View 5 Replies View Related

Trend Line On Stacked Bar Diagram?

Jul 15, 2014

i have a stacked bar chart, similar to this: [URL] What i need is a trend line, similar to this: [URL] that shows the average of the bottom bar to date.

View 14 Replies View Related

X Axis Chart Range Stacked Line To 100%

Aug 14, 2014

I am plotting a line chart wherein the X-axis is based on % and Y-axis is based on $. I have 5 scenarios wherein they have different ranges. I want to have the X-axis plotted up to 100%. How to get the X-axis stacked at 100%. See attached file.

View 1 Replies View Related

Stacked Column Chart With Rate Line

Nov 9, 2006

Here's a sample of a chart that I want; However, I want the bar chart to be a stack chart as I have multiple "Failure modes" per month that I want to show the number(or count) of failures per month. Then I want the line chart to remain the Complaint Rate for that month.

I just can't seem to figure it out.

This chart pulls from a data set that looks something like this: ....

View 9 Replies View Related

Stacked Column With Average Line On Secondary Axis?

Apr 30, 2014

I have a stacked column chart that I need to show an average on, that is on a second axis and shown as a line rather than a column.

I have tried moving it to a secondary axis but then it keeps changing the graph to show only the average.

this is just one of about 25 graphs I am having to do like this.

stacked 2 axis.xlsx

View 2 Replies View Related

Clustered And Stacked Charts Including Line Graphs

Mar 15, 2012

I need to show a chart with new and return visits 2 years side by side. I also need to show a budget line and 2 seperate utilization lines. How to show this.

View 1 Replies View Related

Line Graph Not To Continue The Line If There Is Nothing In Row 10 Of The Table

Nov 6, 2009

With the attached spreadsheet i cannot workout how with the line graph not to continue the line if there is nothing in row 10 of the table.

for eaxmple if there is no value in cell M10, i would like the actual addtion line to stop at the last value on the graph that was in L10.

View 4 Replies View Related

How To Change Line Thickness In Line Graph

May 21, 2010

I have a chart sheet with a line graph that contains two series: I want to change their thickness, but I am not able to format it with VBA.

View 6 Replies View Related

Overlay Line Chart On Top Of Stacked Column Chart?

Feb 15, 2012

I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.

View 9 Replies View Related

How To Add Series Without The Graph Line

Apr 14, 2014

Is there any possible to add a series to a graph table without having the line in the Graph. i just want to show the difference for information and not in the graph?

i have tried some different things (like having the difference in white so it is not visible, formatting the Axis etc)

See attached picture. Excel 2.JPG

View 4 Replies View Related

Adding Line To Bar Graph?

Jan 20, 2014

I am trying to recreate the screen grab that I have copied and pasted in (purple bar chart). I am to create the bar chart, but I am unsure how to create the dotted line which is the national average.

View 3 Replies View Related

How Do I Not Graph A 0 Value On A Line Chart

Oct 26, 2009

I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?

View 9 Replies View Related

Formatting Line Graph

Feb 15, 2007

how to have different format on a line grapgh. I have a series of data points for sales figures. The first 10 are actual data and the next 5 are projections. I want to have a line graph with solid color format for the actuals and a dashed format for the projections.

View 3 Replies View Related

Line Graph With 2 Lines Per Person?

Sep 15, 2013

I need to create a line graph that has 2 lines for each person, one with the amount, one with the points. The X-Axis is by Weeks going up. How can I do this without making a separate series for each? I've attached an example.


View 1 Replies View Related

Line Graph In Descending Order

Dec 8, 2009

How do i achieve the graph that is on the pdf with the data in the workbook i've attached. i cant work it out?

View 2 Replies View Related

Shade In Area Under Line Graph?

Dec 1, 2011

What's the best way to shade in the area under a line graph?

View 1 Replies View Related

Combination Line / Area Graph

Feb 28, 2012

I have two line graphs I plot on a 12-month graph. In addition to these lines, I have a range, high, mid, low, for target percentages. Currently, I have plotted the high, mid, low lines and made them dashed. What I would like to do instead of just having these ranges shown as lines (w/ the graph background showing), is use the area graph function to color shade just the area between the high, mid, and low. Is this possible?

View 2 Replies View Related

Line Graph Based On Date Possible?

Oct 26, 2012

I have a question about creating a line graph, here's the scenario:

Once per week I update our inventory quantity in cells B1, B2, B3. I'd like to show these quantities on a graph which compares the quantity with the date. When the quantity gets updated it would automatically add week 2, when the quantity gets updated again it would again expand the graph and add week 3. Is this even possible?

Week 1
Widget 2
Hammer 1
Saw 6

Week 2
Widget 4
Hammer 1
Saw 6

View 2 Replies View Related

Static Comparison Line On Graph

Sep 22, 2013

I have a bar graph (horizontal) for the values say Jan 1.25 Feb 2.63 Mar -1.5. This works fine; now I would like to insert static comparison lines for the values 2 and -2, i.e. a straight valued at 2 that goes Jan to Mar and another straight line at -2 from Jan to Mar..

View 2 Replies View Related

Line Graph Show No Value When No Value Is Inputed

Dec 29, 2008

X-Axis = Week1:Week13
Y-Axis =Revenue for each week.

I have a line graph. If "Week9:Week13" have no value, my graphs line drops to 0. How do I make my line graph show no value when no value is inputed for "Week9:Week13"? I think I need to incorporate the =NA() in the original formula but I'm not sure how to do this.

View 9 Replies View Related

Third Axis Data - Line Graph

Apr 24, 2007

I have a line graph that contains information for the following products,

Boats , Cars & Bikes.

The chart works well but i would like to show the numbered scale of each product & i can't work out if this is possible in excel.

Currently i can only get two data showing for the axis.

I would like to show all three & just use a color to indicate which data corresponds to which product.

In my attached example: I have data for both Cars (blue) & Bikes (green) but i would like to also show data for the graph scaling for Boats (pink).

View 4 Replies View Related

Combined Bar And Line Graph/Chart

Jul 1, 2008

creating a graph / chart using Ms Excel? I've been trying to do it myself but to no luck as I'm just a novice Ms Excel user. I'm trying to create a bar graph and combine with line graph based on these data. kindly refers to my attachment image for an example of desire graph. For line graph, it should display individually based on the given data. These are my daily data and I want to have an analysis graph so that I could monitor my computer's usage and its efficiency.

Computers Data Usage
Computer01 10 50.00%
Computer02 691 68.89%
Computer03 107 81.03%
Computer04 190 81.25%
Computer05 2099 82.89%
Computer06 1247 50.88%
Computer07 2786 10.00%
Computer08 69 22.00%
Computer09 300 18.00%
Computer10 1829 87.07%
Computer11 746 27.43%
Computer12 437 91.33%
Computer13 301 62.50%
Computer14 24 40.00%
Computer15 93 83.33%
Computer16 192 92.45%

View 5 Replies View Related

Export Graph Trend Line Equation

Jan 17, 2014

Is there a way to get an equation for a trend line and have excel automatically export the equation to a cell where it can be used. The only way i currently know how to do this is to manually type the equation.

View 8 Replies View Related

Copyrights 2005-15, All rights reserved