+ Reply to Thread
Results 1 to 1 of 1

column charts: stacked / non stacked hybrid ??

  1. #1
    Registered User
    Join Date
    07-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2007
    Posts
    1

    column charts: stacked / non stacked hybrid ??

    Hi
    I have some data I need to try and put into a column chart. I need to combine several colums of data (but not all columns)into one overall column but have each data series that make up the total coloured differently.

    e.g. I have income from 3 different sources (say Curly, Larry, & Mo), but one expenditure source. I want to produce a stacked column chart for the income (with the 3 sources in different colours), and then have the expenditure along side the income column.
    Income is say Curly £40, Larry £30, Mo £30. Expenditure is £80. I want the income in 1 column to total £100 (split between the 3 sources each a different colour) and the expenditure of £80 along side the income column.

    I have attached a simple example which might explain things better.

    Thanks

    James
    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