I am very new to excel charts and apologise if this is a silly question.
My chart has the following fields
strongly agree
agree
neither agree or disagree
disagree
strongly disagree
The fileds are represented based on the number of responses
The X and Y axis currently intersect where there is 0 i.e. no responses.
Is it possible to make the axis intersect below the neither agree or disagree field? This would make all the other fields (disagree, strongly disagree, dont know) fall below the axis.
I have uploaded my chart for reference
Last edited by ashmott; 10-02-2011 at 06:55 PM.
You would need to use negative values for those scores.
You will also need to reverse the series order for those 3 series otherwise DK will appear before S.Disagree in the stack.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks