I've just started getting into pivot tables and I'm trying to build a graph showing progress of several keywords, as shown in the first screenshot. Basically, each keyword has 3 numerical values, from 3 different weeks in May. I want to build a line chart that shows the progress of each keyword over these 3 weeks.
This is the pivot table I am working with
excel1.jpg
And this is the graph I'm trying to customize and how it currently looks.
excel2.jpg
I tried ticking "Values in reverse order" but the keywords at the bottom of the graph go on top instead of the number order being reversed.
Ultimately, I would like it to look something like this.
I'd appreciate any suggestions on how to make this happen. Sorry if I haven't been clear enough, English is not my native language.
Thanks in advance!
Edit: Turns out the reason why I'm having trouble with the report is that the value "-" in the table is converted into 0s. Not sure how I could format the table considering 1 is the maximum value of a cell and 0 is the exact opposite.
Bookmarks