+ Reply to Thread
Results 1 to 4 of 4

stacked chart percentage

  1. #1
    Registered User
    Join Date
    08-31-2017
    Location
    Eindhoven, Netherlands
    MS-Off Ver
    Microsoft Excel for Mac (version 15.36)
    Posts
    1

    Question stacked chart percentage

    Heey guys,

    Does anyone have some experience on the problem below?
    I am having the following problems when trying to create a stacked chart. I would like to make adjustment in the chart below.
    Since I would like to make a similar chart with different data. For this example, assume the y-axis is different (e.g. % total revenue generated by selling televisions) and that the numbers in the chart stay the same.

    I would like to adjust the chart in a way so that I can create a stacked chart, for example i would like to depict in the chart:

    1999: 10 % of total revenue generated by selling televisions, of this 10%:
    - 40 % plasma tv
    - 30 % amoled tv
    - 30 % led tv


    2000: 11% of total revenue generated by selling televisions, of this 11%:
    - 60 % plasma tv
    - 20 % amoled tv
    - 20 % led tv


    bar-chart-global-sales-of-televisions.png

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: stacked chart percentage

    Pictures without Excel file are useless

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,363

    Re: stacked chart percentage

    It is not clear to me what you are having difficulty with. A sample file would help, as sandy666 noted.

    You say that you want to create a stacked bar chart (your picture is a column chart, but the ideas I suggest are basically the same for column or bar charts) with different data. Charts don't create or analyze data, so the first step to create a stacked chart with different data will be to compute the new data in the spreadsheet. Do you have ranges that compute these "percent of percent" values in your spreadsheet? Have you got these data arranged in a suitable table? I would expect something like:
    Please Login or Register  to view this content.
    Select this range and insert your stacked bar or column chart. Format chart elements as desired. It often seems that most of the work is in building the spreadsheet and not in creating the chart.

    Can you build a table like that? What would you need help with?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    02-22-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    84

    Re: stacked chart percentage

    Untitled.gif

    Do some extra calculatrion to make your data table to produce your expected chart type. keep change your sale unit in percent with year sale percent.

+ 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. Pivot chart stacked, axis in values labels in percentage
    By rpinxt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-01-2016, 03:42 PM
  2. Replies: 1
    Last Post: 08-24-2016, 04:15 PM
  3. changing time into percentage on a stacked chart
    By dougers1 in forum Excel General
    Replies: 1
    Last Post: 05-03-2015, 11:37 AM
  4. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  5. Replies: 2
    Last Post: 11-02-2011, 12:49 PM
  6. Creating a stacked column chart with percentage in the graph
    By MQ in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-10-2011, 02:53 PM
  7. How do I combine a line and a percentage stacked column chart?
    By Liza in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2005, 10:06 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