Hey,
I have survey data that i am presenting. I want to make it visually appealing. I have set up three columns, Positive, Neutral, and negative based on the data recieved in the survey.
I have a Stacked Clustered Bar Chart. I am trying to format my chart to have the negative values go on the left of the Y Axis, and the Positive on the right. I then want the NEutral to be in the middle of the X axis, split on both Sides. I am comparing three years of data. Hence the clustered graph.
If I make the negative responses negative it moves them to the left side, however they are not negative%
Here is the attached sheet.
Sample.zip
Thanks
Bookmarks