Forum Discussion
Overlapping Column Charts...?
Hi tschmidt87,
According to your description, you have created two charts, one contains grey color columns and the other contains colorful columns, right?
In your scenario, the Y-axis Start and End values can't be specified based on the maximum value of current chart values. As you have set the fixed value for both Start and End property, the Y axis coordinate will not change based on the chart values. To work around the issue, I would suggest you create a Line and Clustered Column chart, set Column values as colorful column values, and lines values as original grey column values. Set both Start and End property Auto for Y-axis(column) and Y-axis(Line).
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi tschmidt87,
According to your description, you have created two charts, one contains grey color columns and the other contains colorful columns, right?
In your scenario, the Y-axis Start and End values can't be specified based on the maximum value of current chart values. As you have set the fixed value for both Start and End property, the Y axis coordinate will not change based on the chart values. To work around the issue, I would suggest you create a Line and Clustered Column chart, set Column values as colorful column values, and lines values as original grey column values. Set both Start and End property Auto for Y-axis(column) and Y-axis(Line).
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Although this approach does not visualize it the same way, it kind of gets the job done. Thanks for the tip Qiuyun :)
hi Qiuyun,
I need help if you don't mind. I need for future months to show the forecasted (latest estimates) numbers in different colour...
FYI red bar is Actuals, yellow line is plan
