All,
am creating stacked charts with a number of categories' data. I have 5 rows of data. For each month, I want to see two stacked columns (i.e. a stacked column with 3 rows of data, followed by a separate stack with the remaining two rows of data - only in the same chart)
Using a normal stacked chart - by adding series, the remaining two rows of data are added to the first stack, thus creating a single stack with 5 constituent sets of data.
Could anyone help? Does this make sense?
Thanks, in advance,
bardo
Hi,Originally Posted by bardo
not 100%, but perhaps a look at some of Andy Pope's charts might help, firstly try http://www.andypope.info/charts/stackside.htm
---
Si fractum non sit, noli id reficere.
Thanks - those have definitely helped (and impressed my boss at the same time)
Cheers,
bardo
Adding to Brian's, here's another to take a look at and impress your Boss even more
http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/Charts/...eAndBelow.html
oldchippy
-------------
![]()
![]()
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks