Hi all,
I have a line and clustered column chart with many details.
The columns representing $$ coming in and out, and the line showing balance.
The difference between "Balance" and the $$ coming in and out is too big, hence I wanna add a secondary axis for "Balance".
But when I choose secondary axis, the horizontal axis details changed and the data for secondary data doesn't match.
The excel sheet shows an example and the picture shows my actual project difference.
Bookmarks