How to configure axis value range in combo charts

[dwayne_winters]

I am trying to create a combo chart, where one value axis contains values in the millions, and the other contains values less than ten. When I create the chart, it appears that I can only define one range that applies for both axis.

Does someone know how I can configure the range for the second axis?

Thanks in advance...

[Former Member]

Hi Dwayne,

there is a value axis and a category axis. So you can configure both axis.

Best Regards,

Marcel

[dwayne_winters]

Sorry - I did not make myself clear. In a combo chart, I have 1 category axis and 2 value axes (2 data series). The interface appears to only allow me to specify one range for the value axis, but my series are so drastically different, that using one range is not practical.

Thanks again...

[Former Member]

Hi Dwayne,

if you need to value axis, then you need two charts.

You can create a second chart and make it transparent, then overlay the first chart. Maybe it works, but I'm not sure, because I didn't try it. But I suggest you to use two charts if the values are so drastically different.

Best Regards,

Marcel

[dwayne_winters]

Thanks for the response, but overlaid charts does not produce a desired result.

[Former Member]

so there is still not a way to get two value axes? If not, this is very confining when dealing with a combo chart.