I'm trying to organize a stacked bar graph but the graph is just not coming out right. I want the Part Numbers (OX2058, etc) on the bottom, with the chart organized as stacked bars for each part showing the estimated cost, actual cost, etc. The way it's coming out now it stacks all the estimated costs together, all the actual costs together, etc. Can anyone let me know what I'm doing wrong?
bar graph test.xlsx
If you are using the chart wizard, just change the series between columns to rows.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Highlight A2:E5 >> Insert >> Charts >> Column >> 2 - D Stacked Column
Now select the chart >> Design >> Data >> Switch Row/Column
HTH
Regards, Jeff
Perfect, thank you!
You're welcome…glad you have a workable solution and thanks for the feedback...
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Does this one get you closer?
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks