Skip navigation

How to a create stacked column chart with totals?

395 Views 4 Replies Latest reply: Jan 17, 2013 12:25 PM by Badunit RSS
slownick Calculating status...
Currently Being Moderated
Jan 14, 2013 7:18 AM
Sprache erkennen » German
Hi folks,
I am quite new to iWork. I am wondering if it is possible to create a stacked column chart with totals showing on top as a figure. In Excel I can do it with a trick creating a second chart within the first. I know in Numbers I can create a mixed chart and it shows me the totals. BUT unfortunately I do not know how to do it stacked it always ends up as usual bars and columns and second I cannot see a way to hide the actual bar, because I only want the figure. To understand what I mean I made a screenshot.
Bildschirmfoto 2013-01-14 um 16.13.45.png
  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Jan 14, 2013 11:17 AM (in response to slownick)

    I think the best way to do that is two charts overlaid on each other.  Shown below is the start of it.  The first chart is the stacked bar chart of your data. The second is a bar chart of the totals.  In the second chart, I have already selected the bars and set their fill color to None in the Graphic Inspector, removed the Y axis and X axis labels, removed the legend, turned on Value Labels, made the value labels be on top, and changed the font color of the value labels to black. For both charts I chose the same Y axis Min and Max and number of steps. Next I would remove all the other visible parts of Chart 2. leaving only the value labels. And last I would slide Chart 2 overtop Chart 1. 

     

    Screen Shot 2013-01-14 at 2.08.46 PM.png

     

    You can make other changes to get what you want, such as adding text to the totals. You do that with a custom format (in the Chart Inspector, Series tab)

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Jan 17, 2013 12:25 PM (in response to slownick)

    slownick wrote:

     

    Not really what I was hoping for.

     

    I understand and agree.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.