Graph with two y axis complimentary to each other

[Anonymous]

Hi everyone,

I am using a line and a bar chart combined in one graph. In general, I like that the left y-axis is independent from the right y-axis. However, I don't want it this time. The red line is indicating is maximum, so the blue bars shouldn't cross this line (see below). And I can't determine the start and end of the y-axis, because the chart is dynamic (the bars and line can have a value of only 50 instead of 4000). Is there a way or other chart which solves this problem?

Thank you in advance.

[cnweke]

Hi there,

Not completely sure if I truly get your use case but I suppose you can just use analyse and plot a maximum or constant line.

[Anonymous]

Hi @cnweke ,

Thank you for your response. The maximum line is not a constant line! The number (of customers) you see in the plot are all of our customers. But we do have many locations, so the number of customers and the maximum number of customers differ per location and thus selection of the locations.

[cnweke · Accepted solution]

So, like I said if it's not a constant line, just use the maximum line function. It's dynamic and changes based on the maximum value of the blue line. It'll always be on top and shift based on your slicer selections.