+ Reply to Thread
Results 1 to 1 of 1

Stacked columns issue

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    46

    Stacked columns issue

    Hello everyone,

    I'm not sure what I want to create is possible. But I would really need this type of chart.

    I have some products that are produced in different countries. They have individual costs, 3 different ones, and they are updated quarterly. I want to display the trend over time and have the different costs be stacked on top of eachother, forming one column, symbolizing the total cost for that product in that country. (And then be able to compare countries / products w one another etc.)

    I'm stuck as I can't find a way to seperate the costs per quarter. The costs for alla quarters just stack up as one pile. I want Q1's 3 costs to form one column (seperated by color), next to it comes Q2 and then Q3.

    My data set is very big. And I can't change the design of my source data too much. But is there some way I can get this to happen?

    Thank you!
    Emma
    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)

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