+ Reply to Thread
Results 1 to 10 of 10

Bar charts for left and right part

  1. #1
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Bar charts for left and right part

    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.
    Attached Files Attached Files
    Last edited by toplisek; 06-03-2020 at 01:12 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Bar charts for left and right part

    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 table
    Please Login or Register  to view this content.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: Bar charts for left and right part

    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.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Bar charts for left and right part

    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.

  5. #5
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: Bar charts for left and right part

    Thank you for the information. I will try on my own. Nice tutorial.

  6. #6
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: Bar charts for left and right part

    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
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Bar charts for left and right part

    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.

  8. #8
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    208

    Re: Bar charts for left and right part

    I tried Select "Store A" data series -> Format series but it seems Professional Excel 2007 does not support the same names.

  9. #9
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Bar charts for left and right part

    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.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Bar charts for left and right part

    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.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Left Click Third Part Application
    By coveee1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2015, 02:24 PM
  2. Splittin Postcodes into first part only with Left Keep
    By kelvin156 in forum Excel General
    Replies: 6
    Last Post: 09-24-2014, 09:00 AM
  3. Extract text left and right of character part 2
    By stuartm4h in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-01-2013, 07:12 AM
  4. [SOLVED] 2 parts - Part 1 - Add an X to both the left and the right on a column of 250 numbers
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 07:16 AM
  5. Slect left and right part of text
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2006, 05:55 AM
  6. [SOLVED] return left most part of cell
    By Pat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-09-2005, 12:05 PM
  7. [SOLVED] Returning left part of cell before a character
    By Alan in forum Excel General
    Replies: 5
    Last Post: 01-23-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1