Need Help to create Coumn Chart Like Stacket Bar with three value.
Dear All Experts,
I want to make a stacked like column chart which contains thee value. but showing two bar. First I wan to share the example. file attaching having problem so I insert an image to understand. Sample.jpg
in the image you can see sample values and sample chart design. I want to create this type of chart both normally and with pivot. with pivot I cannot change or select data. can any one please give the solution How I can do this or is it possible to do?
Thanks in advance.
You can do this by creating 3 data series, and hiding one of them.
Create a stacked bar chart, with the three series - total sales, commission, and profit
Change the Chart Series Type for Total Sales to 'Line'
Add data labels to all three series
Hide the line chart by formatting the line as 'No Line'
Hope that helps, let us know if you get stuck
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
Thanks for your reply. yes this process helps me lot. Now it can be shows like what I want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks