+ Reply to Thread
Results 1 to 2 of 2

Can't work out to get the data I want into a table.

  1. #1
    Registered User
    Join Date
    12-19-2021
    Location
    NW England
    MS-Off Ver
    MS Office Professional 2013
    Posts
    5

    Can't work out to get the data I want into a table.

    Let me try and explain

    I want to have a few line graphs on a spread sheet.

    The first I want is 5 different lines and capture the data from row 110 (Period Total) which is a running total of the below
    ACTUAL (C105:109) , FORECAST (D105:109) , VS BUDGET (E105:109) , VS LFL (F105:109) & VS OTHER VENUE (G105:109)

    Time frame would be B105:B109 which is a period total of 4 or 5 weeks.

    Screenshot 2022-03-20 at 17.35.04.png



    Once I understand this I will replicate 12 times and have a Total 12 month table

    Hope this makes sense
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Can't work out to get the data I want into a table.

    Just select the range B104:G110 and from the Ribbon choose Insert and Pick the line Chart

    Given the variances are a different order of magnitude it would be better to plot those lines on the secondary y axis.

    See attached
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Functions (SUM) not work with Data Table range
    By iqbal.88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2017, 07:13 AM
  2. Can pivot table and data table work together?
    By oscarchow1990 in forum Excel General
    Replies: 3
    Last Post: 03-28-2017, 10:33 AM
  3. [SOLVED] Data validation with the table feature on another worksheet dosent work
    By Masun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2013, 06:54 AM
  4. Replies: 2
    Last Post: 10-08-2012, 03:47 PM
  5. Trying to get a Pivot Table to work with variable source data
    By nakedbamboo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2012, 04:04 AM
  6. [SOLVED] how do i get my data table column inputs to work?
    By wms in forum Excel General
    Replies: 0
    Last Post: 02-14-2006, 04:30 PM
  7. Input cell on Data Table will not work
    By Sarah Bee in forum Excel General
    Replies: 4
    Last Post: 05-25-2005, 08:11 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