+ Reply to Thread
Results 1 to 2 of 2

Adding data on new tab to summary bar chart

Hybrid View

  1. #1
    Registered User
    Join Date
    02-24-2022
    Location
    Seattle
    MS-Off Ver
    365
    Posts
    12

    Adding data on new tab to summary bar chart

    How do I get the data on a new tab (monthly expenses) to be added to a bar chart on a summary chart (YTD tab). Only the first 5 months of the year have a bar, June is not yet showing.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,020

    Re: Adding data on new tab to summary bar chart

    The following added the June data:
    1. Put the cursor inside the chart and right click the mouse
    2. Select "select data"
    3. Select Add
    4. Clear the Series Values window in the Edit Series dialog box
    5. Select the underlined up arrow at the right end of the window
    6. Select cells C8:C23 from the Jun 2024 sheet
    7. Select OK
    Note that I suggest using name that are more descriptive than series 2 etc. so that it is easier to keep up with which months are included.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Need changes to existing VBA: data layout, bolding, adding summary sheet
    By Rolly1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2023, 01:15 PM
  2. Chart - add in data summary table
    By Rfriesen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2021, 05:54 PM
  3. [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
  4. [SOLVED] Pivot Chart adding data together in line chart
    By jennieS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2013, 05:37 AM
  5. Replies: 3
    Last Post: 02-09-2013, 01:33 PM
  6. adding invoice data to a seperate wookbook summary sheet
    By djnewman17 in forum Excel General
    Replies: 0
    Last Post: 01-16-2013, 05:46 AM
  7. 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

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