Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
stacked bars on 2 axes
Hi,
I want top create a graph for 2 types of utilities. Per utility, I want it to demonstrate on the primary axis the available # of that utility, stacked for actual and planned. On the secondary axis, I want it to show the Power of these utilities, again stacked in actual and planned. So I need 4 stacked columns over 2 axis and in 2 categories over the X-axis. Would be very helpful, thanks! Max |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
stacked bars on 2 axes
Stacked isn't a good way to show actual and planned. How do you compare them
if they aren't adjacent? I would use a clustered chart, with two primary and two secondary series. You have to use empty series to make them not overlap each other: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hi, I want top create a graph for 2 types of utilities. Per utility, I want it to demonstrate on the primary axis the available # of that utility, stacked for actual and planned. On the secondary axis, I want it to show the Power of these utilities, again stacked in actual and planned. So I need 4 stacked columns over 2 axis and in 2 categories over the X-axis. Would be very helpful, thanks! Max |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
stacked bars on 2 axes
Hello Jon,
thanks for your answer; I saw the site you mentioned and used it already for other stuff, but I still want double stacked columns, because it does give a good representation in the way of showing what nr of facilities is already there in a specific region, and how many are yet planned to be erected. The other stacked column wll then show, on another axis, the actual and additional planned capacity of these production-sites. So actually, I am still looking for the answer of this problem, although I thought I had the answer when I used another aditional variable, as (actual+planned), which looks like a stacked column when placed with a 100% overlap, but then I could not NOT let the series on the different axis overlap, which therefore does not solve the problem, unfortunately.. Regards, Max "Jon Peltier" wrote: Stacked isn't a good way to show actual and planned. How do you compare them if they aren't adjacent? I would use a clustered chart, with two primary and two secondary series. You have to use empty series to make them not overlap each other: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hi, I want top create a graph for 2 types of utilities. Per utility, I want it to demonstrate on the primary axis the available # of that utility, stacked for actual and planned. On the secondary axis, I want it to show the Power of these utilities, again stacked in actual and planned. So I need 4 stacked columns over 2 axis and in 2 categories over the X-axis. Would be very helpful, thanks! Max |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
stacked bars on 2 axes
Well, I don't know what it looks like, but it sounds like you want
clustered/stacked columns: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hello Jon, thanks for your answer; I saw the site you mentioned and used it already for other stuff, but I still want double stacked columns, because it does give a good representation in the way of showing what nr of facilities is already there in a specific region, and how many are yet planned to be erected. The other stacked column wll then show, on another axis, the actual and additional planned capacity of these production-sites. So actually, I am still looking for the answer of this problem, although I thought I had the answer when I used another aditional variable, as (actual+planned), which looks like a stacked column when placed with a 100% overlap, but then I could not NOT let the series on the different axis overlap, which therefore does not solve the problem, unfortunately.. Regards, Max "Jon Peltier" wrote: Stacked isn't a good way to show actual and planned. How do you compare them if they aren't adjacent? I would use a clustered chart, with two primary and two secondary series. You have to use empty series to make them not overlap each other: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hi, I want top create a graph for 2 types of utilities. Per utility, I want it to demonstrate on the primary axis the available # of that utility, stacked for actual and planned. On the secondary axis, I want it to show the Power of these utilities, again stacked in actual and planned. So I need 4 stacked columns over 2 axis and in 2 categories over the X-axis. Would be very helpful, thanks! Max |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
stacked bars on 2 axes
Thanks Jon!
Stacked & clustered was whta I was looking for, then assigning them to two axes does the job. regrads, Max "Jon Peltier" wrote: Well, I don't know what it looks like, but it sounds like you want clustered/stacked columns: http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hello Jon, thanks for your answer; I saw the site you mentioned and used it already for other stuff, but I still want double stacked columns, because it does give a good representation in the way of showing what nr of facilities is already there in a specific region, and how many are yet planned to be erected. The other stacked column wll then show, on another axis, the actual and additional planned capacity of these production-sites. So actually, I am still looking for the answer of this problem, although I thought I had the answer when I used another aditional variable, as (actual+planned), which looks like a stacked column when placed with a 100% overlap, but then I could not NOT let the series on the different axis overlap, which therefore does not solve the problem, unfortunately.. Regards, Max "Jon Peltier" wrote: Stacked isn't a good way to show actual and planned. How do you compare them if they aren't adjacent? I would use a clustered chart, with two primary and two secondary series. You have to use empty series to make them not overlap each other: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Max" wrote in message ... Hi, I want top create a graph for 2 types of utilities. Per utility, I want it to demonstrate on the primary axis the available # of that utility, stacked for actual and planned. On the secondary axis, I want it to show the Power of these utilities, again stacked in actual and planned. So I need 4 stacked columns over 2 axis and in 2 categories over the X-axis. Would be very helpful, thanks! Max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph 2 bars with 2 different axes? | Charts and Charting in Excel | |||
How to have two axes with stack bars!!! | Excel Discussion (Misc queries) | |||
Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel |