Chart-graph with segments problem due to inhomogeneus data per group

**MasDimash** · 11-07-2012, 05:32 AM

Hei Guys,

I have got some problem with a chart I have been working for the past few days. I want to create a chart that could allow me to show three different panels of an evaluation over 4 differents segment as in the case reported hereafter; my only problem is that the first panel has a common evaluation and I´d rather prefer having just one column chart rather than 4. Is it possible to structure it in this way?

Thank you!
Mas dimash

yellow black white blue
Panel 1 (common for all the segment) 9,1
Panel 2 9,5 9,21 8,33 8,44
Panel 3 8,44 8,17 6,16 8

Chart and graph in paint ;).xlsx

**lmp** · 11-07-2012, 05:46 AM

Hi,

re-arrange your data as in the attached sample file.

Chart the whole data table, then format the Orange series to go on the secondary axis. Decrease the gap width for the orange series, so it gets wider than the default.

Chart and graph.xlsx