+ Reply to Thread
Results 1 to 2 of 2

Adding a new Totals Column

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    Virginia, USA
    MS-Off Ver
    Microsoft 8
    Posts
    1

    Adding a new Totals Column

    Hello!
    I've been googling and playing around with my PivotChart, but I can't seem to add a Grand total column to the end of my chart.
    I need it to total each row, as well as the bottom grand totals, all on the right side of the chart.

    I considered simply adding a column with the sum function, but I need to it to actually be a part of the table.


    Thank you!

    Jess
    Last edited by jstadtler; 11-04-2014 at 03:22 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Adding a new Totals Column

    but I can't seem to add a Grand total column to the end of my chart.
    that will often make the scale quite large
    I tend to use another column and a secondary axis

    Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 0
    Last Post: 10-15-2014, 02:38 PM
  2. Replies: 3
    Last Post: 09-24-2013, 08:04 AM
  3. adding totals up
    By penguinJen in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-30-2013, 07:00 PM
  4. Adding totals of many cells in one column
    By trancelover in forum Excel General
    Replies: 4
    Last Post: 11-03-2010, 08:20 AM
  5. Comparing/matching totals in a column to totals in a row
    By Nicole L. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2005, 07:06 PM

Tags for this Thread

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