+ Reply to Thread
Results 1 to 4 of 4

"Totals" Data label in a stacked chart

  1. #1
    Registered User
    Join Date
    03-05-2008
    Posts
    30

    "Totals" Data label in a stacked chart

    Probably an easy answer but i cant figure it out for anything

    I want to show a "summed total" data label for a stacked column chart.

    For example, i am looking at sales tax revenues. The years are broken out on the bottom of the chart (x axis). i have 4 data series, which are broken down by quarters (Q1,Q2,Q3,Q4).

    Now, i want to show visually the difference in the quarters, but have a data label showing the "summed total" for the entire year.

    any help is much appreciated.

    thanks in advance,
    greg

  2. #2
    Registered User
    Join Date
    03-05-2008
    Posts
    30
    and by the way.

    i would like the data label to be automatically updating. I.E. i dont want to just type the sum of the four categories into a text box and put it above each column.

  3. #3
    Registered User
    Join Date
    03-07-2007
    Posts
    74

    Any answer?

    I bellieve I am trying to do something similiar, can you attach a sample file like I have to help get an Idea?

    I would like to track this info quarterly?
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-30-2007
    Location
    Ontario, Canada
    MS-Off Ver
    2003
    Posts
    42
    Quote Originally Posted by gvb
    and by the way.

    i would like the data label to be automatically updating. I.E. i dont want to just type the sum of the four categories into a text box and put it above each column.
    you can use a text box and have it reference a field on a sheet, all you have to do is create your text box, click inside it as if you are adding text and then go up to the formula bar (beside the fx) and enter =cellnumber

    cellnumber being the cell of the sum of the 4 Quarters

    See gvb.zip for an example


    Quote Originally Posted by slipit1
    I bellieve I am trying to do something similiar, can you attach a sample file like I have to help get an Idea?

    I would like to track this info quarterly?

    Well I think this is what you where looking for. see slipit1.zip
    Attached Files Attached Files

+ 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