Cluster Column Graph with Secondary Axis

**apollo1331** · 06-26-2013, 01:06 PM

Hello all!

It's my first time to the forum and I've been pulling my hair out over this, but I can't seem to create a secondary axis for this column graph attached without having the two graphs overlap to create a stacked graph.

Any help is MUCH MUCH MUCH appreciated!

Thanks!

**Steve=True** · 06-26-2013, 02:39 PM

Hi Apollow1331,

I have always added a few columns in between the Site Visits and Submissions then switched the Columns/Rows.

However, Andy Pope had a much better solution, just can't remember it right now.

Steve=True

**judgeh59** · 06-26-2013, 02:44 PM

I don't have 2003 to test this on....In 2010:

1) click on the Submission data set
2) right and choose "Format Data Series"
3) under the series options, choose "Secondary Axis"
4) right on the the new data series and choose "Chart data series chart type" and change it to line graph

again, not sure about 2003....hopefully they are similar enough to help....

**apollo1331** · 06-26-2013, 02:48 PM

Thanks so much!

However...iss there absolutely no way to have 2 columns instead of a column and a line?

**judgeh59** · 06-26-2013, 02:51 PM

not that know of....but that doesn't mean no either...I just don't know....I do know that there are certain combinations of multi-axis graphs are aren't allowed....