CODEWITHSUNDEEP
google-sheetspivot-table
bootica
bootica

Reputation: 771

Adjusting Pivot Chart on Google Spreadsheet

enter image description here

I´ve been trying to a.) see the value in the legend (e.g. Blue = Name A) b.) remove the numbers (ids) at the x-axis

Can anyone guide me in the right direction / help me with this?

Thank you!

EDIT:

The initial data looks like this:

enter image description here

I created a pivot table that is then using SET as columns. Therefore I am not able to the option "Use first row as header".

I found the reason why the x-axis has the values on it: enter image description here

EDIT 2: Thanks for the answer!

Problem is that I can´t choose "row 2 as an option"!

(FYI: Set = Name)

enter image description here

Upvotes: 0

Views: 568

Answers (1)

CMB
CMB

Reputation: 5163

Solution:

Given the table that was sent, you can generate a pivot table with this setup to prepare for graph generation:

enter image description here

Then generated a graph with these settings. Note that Use Row 2 as Headers and Use Column A as Labels are both checked:

enter image description here

The X-axis scale are automatic though, they will be adjusted based on the number of entries (and the value) in the defined X-axis.

Upvotes: 1

Related Questions