Forum Discussion

skancharla's avatar
skancharla
Advocate II
9 years ago

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...
Need Help
OhNoNotThatGuy's avatar
OhNoNotThatGuy
New Member
8 years ago

Hi Everyone,

 

I figured I would add to this since I found a creative solution/workaround that may or may not work for you.

 

Essentially, 2 line graphs, one in front of the other with one graph having the y axis values on the left and the other on the right. The graph in front, set the background to be fully transparent to be able to see the graph in the back. Position, size, and edit formats accordinaly. For me, the one in front has

  • no borders - since had to be sized a little smaller
  • no y axis grid lines - so it doesn't look too messy witht he grid lines from other graph and  being in front you'll see the line graphs instead of the gridline being over it
  • no x axis labels - same as x axis labels on other graph
  • I made the rear graph solid lined, and front graph dotted lined, and just called out the difference in the title

Not perfect, and may not work for all situations but should work for some!

 

TeeGee's avatar
TeeGee
Helper II
8 years ago

If you stack two charts on top of each other like this, how do you get to the one at the back in order to select it and make changes?  Select the one in front and then Format, Send Backward?  It would be nice if there was a visual selector dropdown at least.

 

UPDATE:  Actually, on the VIEW tab there is a "Selection Pane" checkbox where you can select visuals.