Hi everyone,
I’m having trouble figuring out how to display two columns on a line chart with category breakdowns.
What I need is a line chart where one line represents Sales and the other represents Price. However, the Price data is divided into around 20 categories.
When I try to add both measures to the chart and apply a category split, Zoho shows me an error message.
As an alternative, I tried to merge both measures into a single column (using a label to distinguish Sales and Price), but then I ran into a scaling issue — since Sales values are several times higher than Prices, the chart becomes unreadable.
So I have two main questions:
Is it possible to apply a category split to only one of the two measures?
Or, if I merge the data into one column, can I somehow split or customize the Y-axis manually to adjust the scale?
If anyone knows the answer to this, I’d really appreciate your help!
Thanks in advance.