+ Reply to Thread
Results 1 to 4 of 4

The spreadsheet for daily into weekly sales doesn't chart well

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    The spreadsheet for daily into weekly sales doesn't chart well

    Hi,

    I was asked to create a chart to track daily sales and weekly sales of specific monthly products with individual item numbers. The idea is to see what the trends are, if more items are sold on specific days of the week and what type of items are more popular. I showed it to the person that asked me to create it and she requested I add in a column that lists the day of the week in addition to the column where I list the specific date. Other than that she said it looks fine but when I go to show it on a chart it looks like a big mess. How can I fix this?

    Here is a sample of what im doing:
    Attached Files Attached Files
    Last edited by soun; 06-29-2012 at 08:02 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,322

    Re: The spreadsheet for daily into weekly sales doesn't chart well

    Maybe with a pivot table.
    Attached Files Attached Files
    Notice my main language is not English.

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: The spreadsheet for daily into weekly sales doesn't chart well

    Thank you Oeldere. I am not familar with pivot tables but I will look into this. Do you have a translation for what leeg means?

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    12,322

    Re: The spreadsheet for daily into weekly sales doesn't chart well

    leeg = empty (cells)
    eindtotaal = endtotal
    rijlabel = rowlabel
    kolomlabel = collumlable

    Notice I put the weeknummers manualy in the sheet.

    That can also be done by formula.

    Do you have questions, just ask.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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