+ Reply to Thread
Results 1 to 2 of 2

Horizontal left and right bar charts based on different data series

  1. #1
    Registered User
    Join Date
    03-02-2015
    Location
    Berlin
    MS-Off Ver
    Office 2010
    Posts
    5

    Horizontal left and right bar charts based on different data series

    Hello

    my objective is to create charts like in the attached file.

    Can anyone help?

    Thanks in advance.
    Philipp
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,658

    Re: Horizontal left and right bar charts based on different data series

    3 steps:
    1) F7:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down
    2) columns D and E ->Create Bar Chart
    3) formatting: serie 2 (column E) - plot on secondary axis and then delete secondaty horizontal axis

    see attached file

    now you can fine-tune the chart (distance between bars (probably some 30% will do, bar colors, Legend etc.
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. [SOLVED] Add totals to each data series in a horizontal stacked bar chart.
    By maacmaac in forum Excel General
    Replies: 2
    Last Post: 01-13-2015, 12:04 PM
  2. Data ange for horizontal dynamic charts
    By shaz0503 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 11-05-2014, 07:30 PM
  3. [SOLVED] Adding 1 series of data in 234 charts were 3 series already exist
    By Joachimjr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2014, 01:56 AM
  4. [SOLVED] Is it possible to dynamically update a charts data series, based on another cell
    By missydanni in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2013, 11:29 AM
  5. Chart based on horizontal series
    By wittx in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-22-2012, 02: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