+ Reply to Thread
Results 1 to 4 of 4

Adding Table to Excel Chart

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    Excel 2013
    Posts
    188

    Adding Table to Excel Chart

    Hello,

    I'm trying to add a table to the chart in the attached workbook. However, the data table option is greyed out under the add chart element menu.
    Essential, i want to add the table that is highlighted in yellow to the chart area so that they print together.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,205

    Re: Adding Table to Excel Chart

    You could put a data table below a line graph with markers, as modeled in the attached copy of the file, which looks similar to the original scatter graph.
    Note that the graph is produced from the information in the yellow table.
    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.

  3. #3
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    Excel 2013
    Posts
    188

    Re: Adding Table to Excel Chart

    Thanks for the help!
    That is what i was trying to achieve

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,205

    Re: Adding Table to Excel Chart

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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: 9
    Last Post: 02-01-2019, 07:10 AM
  2. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 AM
  3. [SOLVED] Adding an Average on Pivot Table Data Chart
    By greggatz in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 11-27-2012, 11:24 AM
  4. [SOLVED] X-Axis labels disappear when adding data table to chart
    By phacexcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2012, 02:37 PM
  5. Adding a table to a chart
    By nmoore5 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-28-2010, 03:29 PM
  6. Adding vertical lines to a chart which has a data table
    By ultra vires in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-11-2007, 05:54 PM
  7. [SOLVED] Adding a total row to a chart data table
    By John Ortt in forum Excel General
    Replies: 2
    Last Post: 01-11-2005, 01: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