+ Reply to Thread
Results 1 to 3 of 3

Best chart for comparing historic data of 3 years sales along with 3 years shoppers num.

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    31

    Best chart for comparing historic data of 3 years sales along with 3 years shoppers num.

    Hi Guys

    Can anyone suggest the best chart for comparing the last 3 years revenue numbers along with comparing the total shoppers who came to the shopping mall?
    My data looks like this:
    Jan Feb Mar Apr
    2010 Revenue 78,562 72,650 82,885 73,141
    2010 Shoppers 1,489,035 1,416,049 1,762,140 1,472,647
    2011 Revenue 90,459 78,663 92,875 90,816
    2011 Shoppers 1,658,258 1,511,230 1,862,668 2,035,770
    2012 Revenue 95,768 80,091 95,428 86,879
    2012 Shoppers 1,747,950 1,619,746 1,973,751 2,061,795

    Pls HEEEEEEElp!!!

    Rgds
    BI.
    Attached Files Attached Files
    Last edited by BiIntel; 10-16-2012 at 05:06 AM. Reason: Excel sheet attached now with data

  2. #2
    Registered User
    Join Date
    10-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Best chart for comparing historic data of 3 years sales along with 3 years shoppers nu

    No reply yet?????

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Atlanta, USA
    MS-Off Ver
    Office 2003, 2010
    Posts
    230

    Re: Best chart for comparing historic data of 3 years sales along with 3 years shoppers nu

    Use a line graph.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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