+ Reply to Thread
Results 1 to 3 of 3

Charting Negative with Bar Charts

  1. #1
    Registered User
    Join Date
    10-12-2003
    Posts
    15

    Charting Negative with Bar Charts

    I have a stacked bar chart (with primary and secondary axis) that is charting 9 sets of data - one being the total. The total of the data is set to chart in the primary axis behind the other 8 sets of data stacked in a bar chart. The range on the chart is - 20 to 220.

    The data is (64,-13,181,18,29,6,12,32,34). The problem I have here is that the chart is not wanting to show the -13 bar below the 0 base line. For some odd reason it is starting all bar charts at the 20 mark instead of 0. If the bars would start charting at 0 I would have it done.

    What I need is for the bar charting to begin at 0 for the 8 sets of values - which would allow the negative -13 to be below 0.

    I have never had this done before - see attached.

    THX
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-15-2007
    Location
    Home
    MS-Off Ver
    Office 2010, W10
    Posts
    373
    Hi gacollege

    You are only displaying the primary value axis. If you display also the secondary value axis you'll see that they do not span the same range of values. That's why you don't get the effect you want.

    What you have

    Primary value axis: from -20 to 230
    Secondary value axis: from -50 to 250

    This is why it seems wrong.

    Do the following:

    - Right click on the secondary value axis (or select it in the chart toolbar)
    - choose Scale
    - uncheck Automatic for Minimum and Maximum
    - set minimum to -20
    - set maximum to 230

    Also uncheck the Automatic in the Primary value axis, leave the values -20 and 230.

  3. #3
    Registered User
    Join Date
    10-12-2003
    Posts
    15
    WOW!!!!!!!!!!! I feel so stupid at the moment. Something so simple was a easy fix. If I were to have had the second axis displayed instead of hidden - I would have caught this. I kind of could not fix what I did not see on the screen and I forgot about the range for the second axis.

    THANKS AGAIN!!!!!!!!!!!!!!!!!


    Quote Originally Posted by lecxe
    Hi gacollege

    You are only displaying the primary value axis. If you display also the secondary value axis you'll see that they do not span the same range of values. That's why you don't get the effect you want.

    What you have

    Primary value axis: from -20 to 230
    Secondary value axis: from -50 to 250

    This is why it seems wrong.

    Do the following:

    - Right click on the secondary value axis (or select it in the chart toolbar)
    - choose Scale
    - uncheck Automatic for Minimum and Maximum
    - set minimum to -20
    - set maximum to 230

    Also uncheck the Automatic in the Primary value axis, leave the values -20 and 230.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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