ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stack charts on 2 axis (https://www.excelbanter.com/excel-discussion-misc-queries/142848-stack-charts-2-axis.html)

Roy

Stack charts on 2 axis
 
Hi,

I am trying to create a stack chart for inventory with 10 series. The first
set of 5 are actual dollar amounts and the second set of 5 are forcast dollar
amounts. What I want to do is have the actual dollar amouts as 1 stack and
the forcast dollar amounts to be a stack next to the actual. Is there a way
to do this?

Jon Peltier

Stack charts on 2 axis
 
You don't need them on two axes, just in side-by-side stacks. Look at these
examples:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Roy" wrote in message
...
Hi,

I am trying to create a stack chart for inventory with 10 series. The
first
set of 5 are actual dollar amounts and the second set of 5 are forcast
dollar
amounts. What I want to do is have the actual dollar amouts as 1 stack
and
the forcast dollar amounts to be a stack next to the actual. Is there a
way
to do this?





All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com