automatic access of columns in combined chart

[tomknight]

Hi,

I have created a combined column/line chart to show the relationship between two trends but the column Y-axis always starts at 0 even though the start and end values are set to "auto". I can manually set the start and end values but this isn't a workaround because my data is dynamic and filtered with a slicer so the start and end values need to change.

The line part of the Y-axis is also on auto and suitable start and end values are used but the column part always starts at zero. Is there anything I can do to change this and make the column axis show more meaningful results?

Thanks,

Tom

[Anonymous]

Hi @tomknight,

Do you means show bar and line with same y axis unit?
If this is a case, you can enter to format tab to turn off 'show secondary' option.

Regards,

Xiaoxin Sheng

[tomknight]

Thanks for the response. They have different scales so they need to have separate Y-Axes but the line axis automatically selects an appropriate scale whereas the column one will always start at zero (even though the scale is set to auto). This makes the column variations in my chart impossible to determine (as you can see)

Thanks,

Tom

[Anonymous]

Hi @tomknight,

>>they have different scales so they need to have separate Y-Axes but the line axis automatically selects an appropriate scale

whereas the column one will always start at zero (even though the scale is set to auto).

If that is a case, current I also haven't found any effective method to work through this. Maybe you can try to submit an idea with suggestion to help us improve this feature.

Regards,

Xiaoxin Sheng