+ Reply to Thread
Results 1 to 2 of 2

Layout for multiple countries, traders and years

  1. #1
    Registered User
    Join Date
    02-03-2015
    Location
    Singapore
    MS-Off Ver
    Windows 7 64 bit
    Posts
    1

    Layout for multiple countries, traders and years

    Hi,

    I need a good way to layout this information on a spreadsheet as well an an appropriate chart for it:

    My company sells high end cameras through a network of dealers in 10 different countries.

    Each country has two or three dealers.

    Each dealer sells anywhere from 1 to 10 cameras month.

    There are four different camera types - C1, C2, C3 and C4.

    Each camera is priced at $400, $550, $650 and $850 respectively.

    Each dealer has been selling our products since since 2006.

    I want to make a historical chart showing all this information on one-page.

    Any suggestions?

    Cheers.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Layout for multiple countries, traders and years

    Hi Aziz and welcome to the forum,

    Excel works best when in "TABLES" of data. See the attached where I've created a bunch of fake data the way I think you should. Then I did a Pivot Table with a Pivot Chart (With Slicers) that will let you look like a pro when showing this to your boss or staff.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. multiple workbooks, multiple sheets, all same layout. scan all into master workbook
    By tlgdesign in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2014, 05:27 PM
  2. Take Sheet1 layout and Create Sheet2 layout with Macro
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 03:50 PM
  3. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  4. Convert data from column layout to row layout
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 03:28 PM
  5. multiple page layout in worksheet
    By Dowjd in forum Excel General
    Replies: 5
    Last Post: 03-03-2010, 11:36 AM

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