+ Reply to Thread
Results 1 to 5 of 5

Atypical Bar Graph

  1. #1
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Atypical Bar Graph

    I couldn't explain this in the title, but hopefully a picture presents the question well: Spectro Color Range.jpg

    This isn't a normal graph because the X and Y axis don't actually represent true data. The Y axis is more of a label whereas the X axis is the actual range being used. What I'm trying to do is create a bar for a color (color doesn't have to be done automatically) and that bar extends over a certain range on the graph. So in the example, Armour Black is rated from 1100 to 1850 for label 212378 and then Copper Wood is rated from 2600 to 3330 for that same label. These are logically separated horizontally because there is no value in the space between.

    For label 212379, the same thing takes place, but it's offset this time between their own individual min and max. I understand if this would have to be separated by label (one graph for 212379 and one graph for 212378), but my question is if there is a way to do this (or perhaps a better method to represent this using Excel charts). Right now it's all done manually by filling in the cells and drawing the line for the axes, etc.

    Please feel free to ask any questions as to what's going on here.
    Thanks in advance!
    Last edited by Phoenix5794; 09-20-2013 at 08:51 AM.
    Nothing is absolute - a paradox in itself.

    Indirect Dynamic Data Validation (scroll to the bottom of the page)

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

    Re: Atypical Bar Graph

    a variation of stacked bar chart.

    the annotation on the chart could be done woth xy scatter series with data labels linked to cells.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Atypical Bar Graph

    Thanks a lot Andy - it's great! I'm not sure I understand how I can use the xy scatter plot for annotations though. You mean to say that it would be a new graph entirely, without the representation via bars?

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

    Re: Atypical Bar Graph

    I mean by adding a series as xy-scatter and positioning the data points so the data labels appear in the correct place.
    The link the data labels to cell to display required text.

    This free addin will allow you to easily link data labels to cells
    http://www.appspro.com/Utilities/ChartLabeler.htm
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    01-09-2012
    Location
    Rochester Hills, United States
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Atypical Bar Graph

    I see what you mean. I'll try to figure out a variation of this because I'm not going to be the one filling in the chart, so I either need to teach this method to someone else, or devise an easy-to-fill-in way for someone to input this information.

    Thanks again for the help.

+ 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. Replies: 3
    Last Post: 09-14-2012, 11:59 AM
  2. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 PM
  3. Replies: 2
    Last Post: 08-29-2011, 12:29 PM
  4. Replies: 6
    Last Post: 01-25-2006, 02:45 PM
  5. [SOLVED] Hyperlinkage of one graph with another graph or Drill down graph
    By Sanjay Kumar Singh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-03-2006, 08:25 AM

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