+ Reply to Thread
Results 1 to 2 of 2

trouble in creating a splited skated column chart

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    2

    trouble in creating a splited skated column chart

    I have a table like this
    ----------------------------------------------------------------------------------------
    2010 Sales in chocolate Sales in sweet
    A shop B shop Total A shop B shop Total
    Jan 4 0 4 0 0 0
    Feb 4 0 4 2 0 2
    Mar 0 0 0 5 0 5
    Apr 8 0 8 2 0 2
    May 3 0 3 1 1 2
    Jun 5 0 5 4 0 4
    Jul 7 0 7 2 1 3
    Aug 4 1 5 2 0 2
    Sep 1 1 2 4 0 4
    Oct 3 0 3 0 0 0
    Nov 1 1 2 2 0 2
    Dec 4 0 4 1 1 2
    Total 44 3 47 25 3 28
    ----------------------------------------------------------------
    I would like to create a skated column chart with sales in chocolate in one column with 2 colours for shop A and shop B, and one similiar column for sales in sweet for shop A and shop B for each month. How can I do this ??

    Thx for your help ~~~.~

  2. #2
    Registered User
    Join Date
    09-11-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: trouble in creating a splited skated column chart

    Sales.xlsx
    I attached the file here for more easy browsing ..

+ 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