Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a stacked column/line chart combination?
I am trying to format a line/stacked column combination chart. I want to
show the delay on each of several machines as a stacked column, and then I want to show a line representing the goal for the down time, the goal being a set value, so the line will be straight across. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a stacked column/line chart combination?
Simples way is to plot all the data, stacked columns plus one series for the
horizontal line, as a stacked column chart. Select the series that should be the line, choose Chart Type on the Chart menu, and pick out a line chart style. A bit more involved is to add a line using an XY series of two points, or an XY series of one point with an error bar: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Cori" wrote in message ... I am trying to format a line/stacked column combination chart. I want to show the delay on each of several machines as a stacked column, and then I want to show a line representing the goal for the down time, the goal being a set value, so the line will be straight across. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a stacked column/line chart combination?
Maybe my problem lies in how I am plotting my data. I can make a stacked
column, but I guess I'm not sure where I need to be putting my data that I want displayed as a line. The line will be straight across, it is simply a down time report that shows the amount of down time on different machines, which is what I want stacked, and then the line would represent the allowable maximum goal for the down time, which is one set value. So I am showing each machine's time stacked, compared to the goal. "Jon Peltier" wrote: Simples way is to plot all the data, stacked columns plus one series for the horizontal line, as a stacked column chart. Select the series that should be the line, choose Chart Type on the Chart menu, and pick out a line chart style. A bit more involved is to add a line using an XY series of two points, or an XY series of one point with an error bar: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Cori" wrote in message ... I am trying to format a line/stacked column combination chart. I want to show the delay on each of several machines as a stacked column, and then I want to show a line representing the goal for the down time, the goal being a set value, so the line will be straight across. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a stacked column/line chart combination?
If your data can make a stacked column chart with the line's data included
at first as another stack in the column, then it's arranged appropriately, and you only have to change the series type as I've described. If the data for the line is not connected in the sheet with the other data, you can add it to the chart, either using Copy/Paste Special or Chart menu Source Data Series tab Add button. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Cori" wrote in message ... Maybe my problem lies in how I am plotting my data. I can make a stacked column, but I guess I'm not sure where I need to be putting my data that I want displayed as a line. The line will be straight across, it is simply a down time report that shows the amount of down time on different machines, which is what I want stacked, and then the line would represent the allowable maximum goal for the down time, which is one set value. So I am showing each machine's time stacked, compared to the goal. "Jon Peltier" wrote: Simples way is to plot all the data, stacked columns plus one series for the horizontal line, as a stacked column chart. Select the series that should be the line, choose Chart Type on the Chart menu, and pick out a line chart style. A bit more involved is to add a line using an XY series of two points, or an XY series of one point with an error bar: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Cori" wrote in message ... I am trying to format a line/stacked column combination chart. I want to show the delay on each of several machines as a stacked column, and then I want to show a line representing the goal for the down time, the goal being a set value, so the line will be straight across. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do a combination STACKED column and line chart on 2 axis | Charts and Charting in Excel | |||
3D column chart, stacked | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel |