+ Reply to Thread
Results 1 to 4 of 4

Lock Height and Color of stacked Bars of Chart with Rows

  1. #1
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Lock Height and Color of stacked Bars of Chart with Rows

    Hi

    I am stuck in 2 issues.

    1-
    I have a chart that needs to be printed with bars EXACTLY in front of related data rows. The chart needs to be manually resized to get the bars in exact line with related data Rows. Is there some automatic way (macro or otherwise) so when the chart is created it should have bars in exact line with related data rows?

    2-
    My data has Headings and sub-heads. Is it possible that chart bars for Headings are a bit different than bar of sub-heads? Difference can be color difference or it can be thickness, shape etc difference.

    File is attached
    Attached Files Attached Files
    Last edited by caabdul; 02-13-2018 at 09:12 PM.

  2. #2
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Lock Height and Color of stacked Bars of Chart with Rows

    So seems above things impossible in excel?

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

    Re: Lock Height and Color of stacked Bars of Chart with Rows

    It's not impossible but you would need to make some adjustment to the cells.

    First problem is category spacing in chart is equal. Whereas your row heights are not, so make them all the same.

    If it's one chart then set the fill to none and align by manual adjustment.

    If multiple charts you could then use VBA to move the plot area top and height properties. The complicated thing is you actually want to align the plotarea InsideTop and InsideHeight properties but these are read only.
    So you would need to adjust the properties you can change, Top and Height, but check the InsideTop and InsideHeight values.

    As for formatting category labels, the formatting of the axis is applied to all items.
    You could fake the axis labels using extra series.
    http://andypope.info/charts/hiliteaxislabels.htm
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Lock Height and Color of stacked Bars of Chart with Rows

    Sorry, unfortunately I have different row sizes

+ 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] Combine stacked columns and stacked bars in a chart
    By maboho93 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-09-2018, 07:52 AM
  2. Mixed Chart - Stacked Bars X-Y
    By Renegade27 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-17-2014, 08:38 PM
  3. coloring bars in a stacked bar chart (Yamazumi chart) on basis of text
    By Rob201 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2014, 04:56 AM
  4. Help hiding zero value bars in stacked 3d bar chart
    By tuna666 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-17-2013, 07:12 AM
  5. How to chart 2 stacked bars per day?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-24-2009, 11:59 AM
  6. Bar Chart With Variable Height Bars
    By mr_diss in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-18-2007, 01:08 PM
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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