Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Data labels on graphs

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created some graphs, and I want to add % data labels to each bar. The %s aren't included in the source data, as I want to show the % separately - but all I can see is how to do data labels for the data selected.

    Is there any way around this? I hae tried text boxes but Excel is funny and they disappear sometimes!

  2. #2
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Regarding the "disappearance" of the text box. All objects are layered in Excel. If you create the graph first, then the text box, the text box will be on top of the graph. However, if after creating the text box, you re-select the graph, that action temporarily brings the graph to the front. Click outside the graph into a cell. That should then put the graph and text box back into correct sequence.

    If that doesn't work, then if you don't have the drawing toolbar visible, go to VIEWS > TOOLBAR > DRAWING. It should appear in the lower left hand corner.

    Then select the graph, go to DRAW > ORDER > SEND TO BACK. Click outside the graph. Now the graph will be the farthest back object. And the text box will appear in front.
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Ontario
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    % and label ooption is onlt available for pies and doughnuts,

    BUT

    if you add a column which calculates percentages and include it in chart data, in step 3 of wizard you can go to DATA TABLE tab, and click to include a Data Table.

    Result:

    you can have value label at end of bars, and a chart of related percentages under (or next to) the bar chart.

    Let me know if any clarification needed.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •