Results 1 to 2 of 2

Thread: Break line chart on categories in horizontal axis

  1. #1
    Neophyte bobbo-mip-mip's Avatar
    Join Date
    Sep 2020
    Posts
    1
    Articles
    0
    Excel Version
    Microsoft Offce 365 ProPlus

    Break line chart on categories in horizontal axis



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I'm new to excelguru!

    I am creating a combined excel chart to compare financials across different stores within the same entity.
    Specifically, I want to display revenues (clustered columns) and EBITDA margin (line w/ markers) for 2016-2018 for 3 different stores.
    However, I want the line chart displaying EBITDA margin to 'break' for each store, meaning I want it to be discontinuous and only show 3 and 3 values at the time.

    In the attached excel file you can see both the input data and the current chart. In the chart on the right I have the continuous line chart, but I want the one to the left (keep in mind, this is created using the grey input data in the first image, but I want to do it in another way as is it is both time consuming when I have a larger data set than this, and also work bad on the legends (as it shows one legend for each series)).

    Any suggestions are highly appreciated!
    Attached Files Attached Files
    Last edited by bobbo-mip-mip; 2020-09-22 at 10:35 AM.

  2. #2
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    43
    Articles
    0
    Excel Version
    2016
    Simplest fix would be to add column between groups. Add space to category group row in order to get the grouping correct
    Attached Files Attached Files
    Cheers
    Andy

    www.andypope.info

Tags for this Thread

Posting Permissions

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