Hi Steve, interesting question. There is no button that will allow you to turn the axis upside down. Having said that, there might be few ways around it, the easiest one being to rotate bar 90 degrees (that will give you sideways image). Please send us a sample file so we can get an idea whether your data values are frequencies, numerical, categorical etc. so we can give you more suggestions. Thanks, Paola
Attached is the sample file. Its data for a natural search client who is looking at the potition on page (lowest being the best - highest being the worst). What we would like to do is invert the Y-Axis so that if a keyword improves by going down in position the graph actually goes up.
In excel we can select invert axis so that in the example it would start at 41 and end at 1.
Hi Steve - While we consider this idea (reversing the y scale to show descending order), I have a quick fix workaround that hopefully might do the job. Insert new formula field, I called it Negative Position, and multiply [Position] by (-1). Switch to your Graph view and Choose Y scale field to be [Negative Position]. The scale will run from -41 to -9 in this case. If Label choice is Position, the values will be positive score values that you want to compare. Paola