+ Reply to Thread
Results 1 to 2 of 2

Bar Chart with Variable height and width for bars

  1. #1
    Registered User
    Join Date
    02-21-2023
    Location
    San Francisco, CA
    MS-Off Ver
    365 for Mac
    Posts
    1

    Bar Chart with Variable height and width for bars

    Hi-

    I'm trying to create a horizontal bar chart that allows for the height of each bar to have a variable, as well as the width. It's difficult to describe without links to examples, but I need the bar itself to have a height based on total dollar value and the width will be a length of time. I'd like to stack a few of these bars to show payments over time.

    I found another forum explaining a very roundabout way to do so but only allows vertical columns, rather than bar charts (because it's based on a 2d area graph).

    I'd welcome any input!

    Thanks,
    Gianna

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

    Re: Bar Chart with Variable height and width for bars

    There is no built in chart for this, you will have to fake it.

    You could use stacked areas as per the column bar version, although you will need to include series to act as padding between each bar set.

    Or, depending on the precision of the width value you could use multiple bars, setting the width gap to zero so they appear as a solid bar.
    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. Lock Height and Color of stacked Bars of Chart with Rows
    By caabdul in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-15-2018, 02:13 PM
  2. How to vary the width of individual bars in a bar chart
    By FrankParisi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-23-2016, 07:46 AM
  3. Excel 2007 : Change width of chart's bars
    By SueWithQuestion in forum Excel General
    Replies: 7
    Last Post: 07-10-2014, 03:23 PM
  4. Replies: 3
    Last Post: 03-22-2013, 12:19 AM
  5. Bar Chart With Variable Height Bars
    By mr_diss in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-18-2007, 01:08 PM
  6. [SOLVED] [SOLVED] variable height variable width stacked bar charts
    By ambthiru in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-18-2006, 07:45 PM
  7. Changing the width of the bars in my chart
    By willrayfield in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-19-2005, 12:11 PM

Tags for this Thread

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