I am trying to create a simple stacked bar chart in Excel 2010 but there must be a problem with the way my spreadsheet is set up, because it results in individual bars rather than 1 stacked bar. I have a column for reason and a column for count.
reason count
picking error 4
short shipped 3
over shipped 2
packaging 2
wrong customer 1
wrong carrier 1
(I would sell my soul to have the chart wizard back...)
Thanks in advance,
Leah
to have a stacked bar you need more than one set of values for each of your reasons
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
[QUOTE=Blake 7;2545635]to have a stacked bar you need more than one set of values for each of your reasons[/QUOTE
Can you attach a really simple spreadsheet with a couple lines of data and the resulting chart? I'm just not understanding what you mean. I used to do these all the time in Excel 2003 and never had this problem.
Thanks,
Leah
sure - just a sec.....
Hiya -
have a look and see if you find what you want - if it doesnt fit the bill describe what you want!
You need to switch row/column data so it plots each point as a series rather than all points as 1 series.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks