Forum Discussion
Dual Y axis in Line chart
Hi, I'm working on a line chart and displaying 2 columns Project count and test count. Project count is in tens of number and test count in thousands.With a single Y axis ,the Project line almost...
I have an issue with the secondary Y-axis data labels. I am trying to figure out a way to turn off the data labels on the secondary y axis line chart. That option probably doesn't exist but having data labels on the secondary y axis makes my graph look super busy.
Guessing that you mean "having data labels on the series elements that relate to the secondary axis"? the whole idea behind adding a secondary axis is to show the scale of those series elements that have a different scale from the primary. You can of course selectively show labels on the various Series elements (Line and clustered column chart--Data Labels--Customize Series). Unlike Excel though, you can't format each data point.
Hope this helps!