Dual Axis Clustered Stack Bar Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to display a data set on a dual axis clustered stack chart. It needs
to be sorted by month for a six month period, with two groups of data, each
with up to 20 types of data in each group. The data is located in an access
database. I have built an extract that will dump data to Excel, sorted by
month, group, and data type. Each data type has a value for that month. The
chart needs to be a bar chart, not a line chart. Any help will be greatly
appreciated.
 
Thanks for the links. I still am struggling with doing both. I don't know
if the charting component supports the Dual axes and the cluster on the same
chart. Both of these examples were helpful, but I need them together. I was
hoping to find an email address on his site, but couldn't find one. I may be
trying to do something that is not possible with the Office charting
components.
Jeff
 
I come by in my free time. It's now 1:40 am, what's that tell you?

It is certainly possible to combine the two effects in a single chart. In fact, the
blank cells in the stacked-clustered charts allow you to put the series onto either
axis without resorting to dummy placeholder series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thank you for the time. It looks like I have some studying to do. I will be
reviewing your page, and will keep posting to this thread as I have problems.
As is normal for my job, I have been given another 'must have' and will have
to return to this on next week. Thanks again for the direction.
Jeff
 
Back
Top