Hi guys,
I have a problem with my PIVOT chart. For some reason it visualises data incorrectly in relation to each other.
What I mean is, I have a line chart, I've linked a printscreen below (I had trouble with posting an image within text...), which has 4 lines for 4 categories. As you can see for example in Jun the orange line says "-1129.81" while the yellow and grey ones beneath both are much higher values "-191,97" and "-254.29" respectively. Why is it that in this chart the orange line is above the other two? It's like with all other months as well. The point of this chart, for me, was to compare the data between those lines, but when they show like this, it's completely useless.
(Dropbox) PIVOT Chart
I'm attaching the file as well, it doesn't really have any confidential data...
Thanks for your help,
Nina
Bookmarks