0

I am trying to plot two different types of data: segmented volumes and rating. In the linked example data sets & charts you will find two different charts that I am trying to combine.

  • The first table has a stacked column (data type A, segmented volume, left axis) and a non-stacked column (data type B, right axis)
  • The second table has a non-stacked (data type A, non-segmented) and a line (data type B)

The goal is to combine the presentation of data type A as a segmented volume (first table) with the presentation of data type B as a line (second table).

Is this type of chart possible in Google Sheets, and if so how do you achieve it?

2

Maybe this is what you wanted (the chart is in the example you linked): enter image description here

I used a combo chart, applies column style for all series, but asked only for the "Total" series to be displayed in the right axis. The series displayed in the left axis were stacked by default.

1

not sure if I understood it so is this what you seek?

enter image description here

  • In a sense yes. Trendlines do convey a piece of the information, but I am looking at a granularity that is weekly, rather than averaging change. Also, if the trendline was at that granularity, the goal would be to only have the trendline, and remove the rating column. (I did realize that I can change the column's color to match the background though.) – mfg May 18 '18 at 18:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.