+ Reply to Thread
Results 1 to 3 of 3

Graph issues with Labeling

  1. #1
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Graph issues with Labeling

    Hi,

    Please see my attached spreadsheet. Tab 1 is just the data. Tab 2 are the graphs. At one point i had all the labels in the graphs as centered, but as the numbers change daily, sometimes the labels would get cut off or be too jumbled together. When you then manual move the labels to be more presentable, the are no longer automated. I am looking for an automated solution, so I will not longer have to manually move around. Also, in lines 48-131 in graph tab, the box that has the total pl will also float around from time to time (maybe how it is linked up). Any thoughts, fixes, ideas, solutions, would be much appreciated. Thank you.

    Graph Question.xlsm

  2. #2
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Re: Graph issues with Labeling

    Hi, just following to see if anyone has any ideas? Thanks

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,746

    Re: Graph issues with Labeling

    There is not a lot of explanation in the spreadsheet to explain where the problem occurs (one chart or all charts), or what kind of solution you might expect. Since all but the first chart are stacked column charts, it seems like this kind of problem would be less likely for those, but I can't be certain of that.

    As far as I can tell, Excel does not have a built in algorithm for avoiding that kind of data label "log jam". Manually moving the labels works well enough, but automating that process is going to be a challenge.

    One idea -- evaluate the need for data labels. What purpose do the data labels serve? Are they necessary to the message of the chart?

    Another idea, instead of data labels inside of the plot area, would you consider a data table at the bottom of the chart? http://www.ehow.com/how_2272792_add-...cel-chart.html

    This would only apply to the first chart (line + column combination). Would you consider a column + scatter combination chart instead? Using a scatter chart type for the line series would add an "x" component to plotting those points. You could then adjust that x component so that, for example, the red/green series is on the left side of each column, the gray series is in the center of each column, and the black series is on the right side of each column. There should be less opportunity for the data labels to overlap.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Labeling A Graph
    By rez3 in forum Excel General
    Replies: 3
    Last Post: 01-14-2016, 12:23 PM
  2. Help to correct graph in two issues
    By tagusriver in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-23-2013, 05:53 AM
  3. Axis Graph Labeling
    By EAGLEBUCKS in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-15-2011, 03:31 AM
  4. a-axis labeling issues
    By dadevil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2011, 06:59 PM
  5. labeling stacked column graph
    By dadevil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2010, 05:01 AM
  6. labeling column bins in a bar graph
    By pkhoosh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-02-2008, 04:58 AM
  7. Labeling of Graph (Data Series)
    By Dustin Deck in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 07:06 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