+ Reply to Thread
Results 1 to 4 of 4

adding components to charts and tables

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Ontario, Canada
    MS-Off Ver
    2013
    Posts
    15

    adding components to charts and tables

    Hello, I'm struggling to add extra fields to my chart and graph.
    I tried calculated fields, but they are cluttering the chart by adding averages for every date from the chart.
    I just need a grand average from the entire date range to be in the table and on the chart.
    Thank you!
    pivot.jpg
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,356

    Re: adding components to charts and tables

    Hello,

    pivot charts are quite limited when it comes to niggly details like that. You may be better off to create a regular chart off the pivot data, calculate the desired average in separate cells with your own formula and add that data as a line series to a combination column/line chart.

  3. #3
    Registered User
    Join Date
    11-07-2019
    Location
    Ontario, Canada
    MS-Off Ver
    2013
    Posts
    15

    Re: adding components to charts and tables

    Quote Originally Posted by teylyn View Post
    Hello,

    pivot charts are quite limited when it comes to niggly details like that. You may be better off to create a regular chart off the pivot data, calculate the desired average in separate cells with your own formula and add that data as a line series to a combination column/line chart.
    Thanks, but every time I try to make a simple chart out of a pivot table it is converted to a pivot chart with limited functionality.
    How do I "downgrade" the pivot chart to a basic chart, please?

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,718

    Re: adding components to charts and tables

    This is a good tutorial for creating regular charts from pivot table data: https://peltiertech.com/regular-char...-pivot-tables/
    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)

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