+ Reply to Thread
Results 1 to 2 of 2

Graph that correlates with the numbers

  1. #1
    Registered User
    Join Date
    12-20-2021
    Location
    Oslo, Norway
    MS-Off Ver
    2016
    Posts
    7

    Lightbulb Graph that correlates with the numbers

    Hi, first of all apologies for if i'm posting this is the wrong thread/forum.

    Need help to set up a graph that correlates with the numbers in the report. Not so great with Excel, so dont know where to start.
    Maybe start with a pivot table first and then set up a graph?

    Column D-G shows what we sell per day,

    Column H-J shows what we get in each week.

    Goal: Increase ordering from weekly, to monthly ordering to get larger volume per pallet, and hence less stacking.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Graph that correlates with the numbers

    You don't add the date in the data. So that info can't be used.

    Maybe something like this.

    See the attached file.

    Please feel free to ask.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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] Formula that correlates cell text to a sheet in workbook
    By the machine in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-19-2018, 11:25 AM
  2. How best to graph these numbers?
    By roemerw in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-30-2017, 12:33 PM
  3. How to get cells with static data to stay in the row it correlates to
    By romeshomey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2015, 12:29 AM
  4. % and numbers on graph
    By pawilsonliftone in forum Excel General
    Replies: 3
    Last Post: 10-17-2014, 01:30 PM
  5. [SOLVED] Cell A1 contains specific #s, place X under row/column that correlates to that #
    By marshak in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2013, 02:43 AM
  6. [SOLVED] Two numbers one is percent of other - how to graph
    By MaddyG in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-22-2013, 10:55 AM
  7. Numbers on a Log scale graph.....
    By chrisbrez2002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2009, 11:57 AM

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