Hi y’all,
I am attempting to visualize sales data over a specified interval of time. The chart is populating correctly, but I want to alter the y-axis label as a currency, rather than as a number (I was $1,000,000 and not 1000000). When I try formatting the numbers as a currency, an error arises. I hope y’all might have a workaround for this issue. Thank you for your help.
// The above image’s error reads: “formatted as text.”
// These are the formatting preferences I’ve stated.
// I’m working with daily sales records, so I grouped them by quarters.