Feb 24 2022 12:18 PM
I have been trying to get data that I incorporated into a Pivot Chart to translate into a line/mountain graph. Unfortunately, the graph seems to auto-generate the y-axis as being monetary value automatically every time, so that I see the results as a V shape (see image) rather than over time (what I'd like to do, so I can see changes over time).
I've included a picture of the pivot chart (with data whited out) as well so you can see what I'm looking for/hoping to use.
Is there a way to re-format or organize the chart so that I can get this chart to show over time rather than auto-setting to monetary value?