+ Reply to Thread
Results 1 to 2 of 2

Help to correct graph in two issues

  1. #1
    Registered User
    Join Date
    11-23-2013
    Location
    Luanda
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help to correct graph in two issues

    Dear Gurus,

    Please help me to correct two issues in graph posted bellow:

    1. first bar is approximately half area of the rest. What is the parameter I have to manipulate to sort this out? Not showed in the print-screen bellow but last bar in the graph has the same problem;

    2. Is there any way to change the place of the y-variables in order to place according to its relative value? I would like to have variable descriptions on left hand side if variable is positive and at right hand side if negative. For instance, bellow, description "08-Soyo" should appear at right hand sid of his bar. Is it possible to do this in Excel 2010?

    Thanks in advance.

    apagar paulo.png

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

    Re: Help to correct graph in two issues

    If the first and last bar are half width then check the vertical axis format, Postion Axis on tickmarks is Between ticks

    Use a dummy series and its data labels to replace axis labels.
    Attached Files Attached Files
    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. Graph not connecting points on graph in correct order
    By davethenave in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-08-2013, 06:49 PM
  2. Histogram and graph issues
    By kryt0n in forum Excel General
    Replies: 7
    Last Post: 07-23-2010, 04:50 AM
  3. Issues with the scale of a graph
    By dante19 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2009, 03:42 PM
  4. Correct word wrap issues in data imported from a text file
    By Bearded Dan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2008, 02:48 PM
  5. More issues with finding the correct entry
    By Neflheim in forum Excel General
    Replies: 2
    Last Post: 01-18-2007, 05:44 PM

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