Panel Charts, Small Multiples, Trellis, Stacked or????

[MikeMikeMike]

Ok so I am knee deep in a charting project and hoping that someone here can clear up something for me through answering a question below.

So I am familiar with a feature back in the day when I was heavy on SharePoint and MS Office Web Components webpart (awesome and I hear a better version is being re-introduced in SP 2010...cant wait!)...creating Panel Charts or Small Multiples I remember being literally one check box.

I start thinking that some of my data may be presented better like this with the reports I am working on.....so I do a little searching.

I find articles like this: http://peltiertech.com/Excel/Charts/StackedCharts.html

Are you serious?! I mean wow...it gets the job done I suppose but **** if I am not wishing I had a SharePoint server up and running right now with the feature I now miss very much.

Point I haven't been able to find a straightforward method or tutorial about how to go about creating multiple charts that share the same axes from a single data sheet which bothers me.

Can anyone help...am I missing something or is that crazy work around in the link above my only option?

Thank you all!

Mike

 

[MikeMikeMike]

12 views and no suggestions?

 

[AusSteelMan]

I built a panel chart (stacked up to 10 panels) to represent up to 10 series of machine data collected at a rate of 1 sec for 2.5 hours.

Followed the instructions here: http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

It did take a while, but worked a treat for my colleague (not even for me).

Tinkered some more to try and develop a template (the colleague wanted to do several charts over time). See here and you should still be able to download the template:
http://www.4shared.com/document/GHCXnmX9/PanelChart-23BoilerTrends.html
which was a part of a post in:
http://peltiertech.com/WordPress/plotting-values-against-limits/


As for "12 views, no suggestions", I am not sure your question was especially clear in what you wanted. If I hadn't done this type of chart previously, I wouldn't have really known what you wanted, other that some reassurance that building your own was most likely to suit you best.

That said, Jon has now built a utility that builds a panel chart for you. I haven't got it as yet, but read this: http://peltiertech.com/Utility/PanelChartUtility.html and see if it suits you.

Good luck,
Darren