I have the same two categories but different years. I kindly ask you to send me Excel file how to do it as I tried many times. Thank you.
I have Office 2007 PRO version. Just need an example. I have enclosed segments for each year.
I have the same two categories but different years. I kindly ask you to send me Excel file how to do it as I tried many times. Thank you.
I have Office 2007 PRO version. Just need an example. I have enclosed segments for each year.
Last edited by toplisek; 06-03-2020 at 01:12 PM.
Not enough information to begin to work out a detailed solution. Can you upload a sample of what you have tried? Can you provide more information about the data you have (specifically how it is arranged in the spreadsheet) and what you need to do with it?
I find that a lot of charting questions are really about arranging data in the spreadsheet. It isn't clear to me exactly what you want the chart to look like, but my initial instinct suggests:
1) Enter/move/copy the "x values" data into the left most column of the range you want to use for the chart. Date/Year seems to be the obvious choice in this case.
2) Enter/move/copy the "y values" data into adjacent columns. In this case, you have two categories, so I would expect a separate column for each category.
3) Select the data and insert the desired bar chart.
4) Fix up any of Excel's mistakes and format the chart as desired.
Sample tablePlease Login or Register to view this content.
Originally Posted by shg
Please find a file. I try to make LEFT-RIGHT mirror for the same category. I hope it is is more clear. It is Diverging Stacked Bar.
You call your desired chart a "diverging stacked bar" chart. I put "diverging stacked bar chart" into my favorite internet search engine and found:
This tutorial: https://peltiertech.com/diverging-stacked-bar-charts/
This argument against their use: https://blog.datawrapper.de/divergingbars/
Another tutorial: https://stephanieevergreen.com/diverging-stacked-bars/
Your Left-Right mirror comment made me think of a tornado chart. Again, put "tornado chart Excel" into a search engine and I find:
Another from Jon Peltier who doesn't particularly like tornado charts so he offers alternatives, too: https://peltiertech.com/tornado-charts-and-dot-plots/
Another tutorial: https://www.excelhowto.com/how-to-cr...tterfly-chart/
A third tutorial: https://excelchamps.com/blog/tornado-chart/
Somewhere in those tutorials should be enough information to build a diverging stacked bar/tornado chart.
Thank you for the information. I will try on my own. Nice tutorial.
I have added Excel data and installed also the XY Chart Labeler. Video is very poor written. How to manage Tornado Chart?
https://www.excelhowto.com/how-to-cr..._Chart_Labeler
Following the numbered steps in the text of the website, you have made it through step 2. Next is steps 3 and 4
3-4) Select "Store A" data series -> Format series -> Plot on secondary axis
5-6) Select Secondary Horizontal axis (at top) -> format axis -> min -2500, max +2500, values in reverse order.
7-8) Select Primary Horizontal axis (at bottom) -> format axis -> min -2500, max +2500
Continue following the steps outlined in the tutorial.
I tried Select "Store A" data series -> Format series but it seems Professional Excel 2007 does not support the same names.
That seems confusing to me. I have a hard time believing that your version of Excel 2007 is that different from my version of 2007. In your file, the blue series is named "Store A" as shown in B1. You should be able to select the blue data series -> Right click -> Format axis brings up the format series dialog. Alternatively, you can select the chart, click on the Design tab of the Chart tools ribbon, select the data series from the dropdown list of chart elements, then click on format selection to bring up the format series dialog. Or any other method you prefer for accessing the format series dialog, but somewhere in your copy of Excel, you should be able to access the format series dialog.
Here is an article with details of how to find the secondary axis option in 2007.
https://newtonexcelbach.com/2010/02/...in-excel-2007/
It's actually for a line chart but it will be the same for a bar/column chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks