Stacked Column and Line Chart

[davidmcgough]

What is the best way to use the Stacked Column and Line Chart for customers while getting the left/right axis to behave?

Right now, I have a dashboard using that visualization type in Incorta, but the left/right y axis seem to have minds of their own. The data we are looking at can range between 10,000 to 100,000 or even millions of dollars in the same time frame, and the two axis will struggle to display the data.

I absolutely need the trend line over the column charts, and this is the only option incorta's visualization tool has for that need.

However, even if I "lock down" the left/right axis with the same hard-coded number limit, i may toggle to a different project/source data that has a completely different range. Think large project in millions, or small project in thousands. So "locking" the axis range is not sustainable if you switch projects

Even if I limit the axis to say 6,000,000, the display will still show $6 million on the left axis, but $6.2 million on the right axis. Super frustrating.

I am looking for a way to have it auto-adjust to the axis to best fit whatever data its showing.

Let me know your thoughts!

Respectfully,

David M

[JoeM · Accepted solution]

@davidmcgough - Here's my solution
1) Move the axis for the line chart to the left

2) Unify the left axis

[davidmcgough]

Hi JoeM, sorry this got buried.

But this solution is BRILLIANT! Exactly what I was looking for. I just did this exact same thing in my dashboard, and it fixed it. 

Thank you so much for the helpful video, that is amazing!

[JoeM]

I'm glad you found it helpful!