Solved

Create one y axis as bar, secondary y axis as line

  • 6 November 2020
  • 1 reply
  • 19 views

Hi Corey,

 

To add a second series along the y-axis, you will want to open the gear menu in the visualization, go to the Y-axis tab, and you’ll see series in the “left axis”. Drag one of the series to the “right axis” to create a secondary y axis for that series. This is described, with pictures, in our documentation here. We also have a video tutorial which outlines this process here. Let us know if you have any difficulties or have any followup questions!

 

 

Cheers,

Jon

 

How can I add the “right axis” to create a secondary y axis as a LINE?

(So the “left axis” = bar and the “right axis”  = LINE)

icon

Best answer by izzy 13 November 2020, 03:16

@JulianaR To change the chart type for a new axis/series, you use the series tab in the viz config, not the axis tab. Scrolling to the bottom of the series tab, you can open each series and change the type (and color) to whatever you want! 

This explains how to do that: https://docs.looker.com/exploring-data/visualizing-query-results#including_multiple_visualization_types_on_a_single_chart

Then, in the axis menu, you create a new Y axis and drag the relevant series to it, per that other example.

View original

1 reply

Userlevel 7
Badge

@JulianaR To change the chart type for a new axis/series, you use the series tab in the viz config, not the axis tab. Scrolling to the bottom of the series tab, you can open each series and change the type (and color) to whatever you want! 

This explains how to do that: https://docs.looker.com/exploring-data/visualizing-query-results#including_multiple_visualization_types_on_a_single_chart

Then, in the axis menu, you create a new Y axis and drag the relevant series to it, per that other example.

Reply