Results 1 to 7 of 7

Stacked Column Graph Glitch

Threaded View

KateKoz Stacked Column Graph Glitch 10-14-2008, 03:32 PM
zhollett I have no idea why but if you... 10-14-2008, 04:23 PM
zhollett Ohh, now I see whats going on... 10-14-2008, 04:38 PM
Andy Pope As zhollett points out the... 10-15-2008, 04:12 AM
KateKoz Thanks 10-15-2008, 10:16 AM
Andy Pope To set the min/max you can... 10-15-2008, 10:19 AM
KateKoz Thanks again 10-15-2008, 10:49 AM
  1. #1
    Registered User
    Join Date
    10-14-2008
    Location
    Loveland, OH
    Posts
    6

    Question Stacked Column Graph Glitch

    I'm having a huge problem with a Stacked Column Graph.
    The bottom half (red striped) graphs the percentage achieved. The remaining (grey) area graphs the percentage away from 100%.

    Basically, this is a thermometer-type graph, showing how close you are to the goal.

    The graph works perfectly as long as the percentage is not 83%-99%. At this point, the graph breaks down and becomes innacurate.

    I have cut out all "useless" data from these sheets and left only what's needed for this issue. The data is in Sheet 1 and links to the graph in Sheet 2.

    The numbers in green (in Sheet 1) are the ones being graphed. The number in blue can be changed to get the desired percentage. If you change the value in blue to anything within the range of $7600 - $9100 you will see the error occur.

    ANY help with this would be GREAT!! I have no idea why this is doing this or how to fix it.
    Attached Files Attached Files
    Last edited by KateKoz; 10-15-2008 at 10:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stacked column graph
    By Vikingex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2008, 02:53 PM
  2. column graph challenge
    By kourgon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2008, 06:20 AM
  3. multiple columns of data stacked into one column
    By beatrice25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2008, 05:01 PM
  4. Increasing and decreasing depending of column C
    By caldera55 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-25-2008, 06:33 PM
  5. Stacked AND side by side column graph...
    By Hornet_MT in forum Excel General
    Replies: 4
    Last Post: 03-01-2007, 10:23 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