+ Reply to Thread
Results 1 to 3 of 3

Chart - add in data summary table

Hybrid View

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    8

    Chart - add in data summary table

    I have a workbook, with several sheets. On sheet1 i have data which i enter weekly. I also have a made a summary (outlined box) of the data.

    I have created a chart to display the data on sheet2.

    I want to add the Summary Data display (from sheet1) on to the chart (sheet2) and have this Summary Data on the chart linked as the data is updated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Chart - add in data summary table

    Why did you take a snip to embed instead of a Camera Tool picture ... they update automatically?

  3. #3
    Registered User
    Join Date
    03-01-2021
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    8

    Re: Chart - add in data summary table

    Thank you for the tip. I was not aware of the Camera Tool picture. Did some looking into this and it works. Thank you again.

+ 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. [SOLVED] Making a Summary Chart Using three columns from data
    By SAnsley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2018, 11:20 AM
  2. [SOLVED] Analyse each of the groups in a Data Table and send results to a Summary Table
    By PeterR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2015, 10:26 PM
  3. Automatic summary table update not using pivot chart
    By kheino1111 in forum Excel General
    Replies: 1
    Last Post: 04-01-2014, 12:34 AM
  4. chart with summary of min/max and average values by data category
    By RogerL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-24-2012, 04:58 PM
  5. VBA Code to create summary table and Chart
    By KPK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2010, 05:40 AM
  6. Summary chart with pivot table
    By arthurlucena in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-29-2010, 08:28 AM
  7. [SOLVED] How do I show summary totals from a pivot table on a bar chart
    By Colleen T in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-21-2005, 10:06 PM

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