How to display two measures (sales and price) divided by categories on one line chart

How to display two measures (sales and price) divided by categories on one line chart

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:

  1. Is it possible to apply a category split to only one of the two measures?

  2. 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.

    • Sticky Posts

    • Tip of the Week - Spot Risky Sales with Conditional Formatting

      In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to apply

    Nederlandse Hulpbronnen