+ Reply to Thread
Results 1 to 2 of 2

Column chart with varying column widths and picture fill help

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    Hull
    MS-Off Ver
    Excel 2003
    Posts
    4

    Column chart with varying column widths and picture fill help

    Hi i have created a column chart with pictures in the series in this case it is doors. i have plotted another series on a secondary axis that shows failure rate of the door. This gives the appearance that the door is been coloured in red the higher the failure rate.

    Is there a way to vary the column widths to show some wide doors and some narrow doors as i have managed to get the height to vary to reflect tall and short doors but need help on this.

    I have found examples for varying column widths however i am unable to insert a picture as the fill.

    I have attached a sample document to help understand my problem

    door chart example.xlsx

    Thanks in advance

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

    Re: Column chart with varying column widths and picture fill help

    Whilst you can use an area chart to produce columns with height and width properties the fill of the area is based on the full width of the plot area and the picture will be cropped where the area is not present. A bit like looking through a window.

    It is possible to create a image to fill the 'window' of each data set but it would not be dynamic.

    Given the current door image it would be easier to use xy-scatter series and draw the doors and the area to fill it with colour.
    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. in excel, can i set varying CELL widths that are in same column?
    By Pam Deshazier, SRHS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 07:15 AM
  2. [SOLVED] Varying Column Widths for Text Import
    By Rytrilius in forum Excel General
    Replies: 3
    Last Post: 11-28-2005, 10:00 PM
  3. Varying column widths
    By djpatwork in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 01:06 PM
  4. [SOLVED] Varying column width in a column chart
    By Silvie Dedkova in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-22-2005, 10:06 AM
  5. Fill down formula using VBA to varying column lengths
    By Lee Jeffery in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 01-28-2005, 08:40 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