+ Reply to Thread
Results 1 to 2 of 2

Partial data versus total on the same chart

Hybrid View

  1. #1
    Registered User
    Join Date
    10-25-2006
    Posts
    48

    Partial data versus total on the same chart

    Hello guys, have a question on excel 2010.
    Is possible to have the following ?

    1) on primary axis, only some of the itens are displayed (as stacked chart) and
    2) on secundary axis, the total for all itens is displayed (as line chart)


    
    |
    | ---------\
    |      ___  \______________        <-   Line Chart (axys 2)
    |     | 1 |                             with total for all itens (1,2,3,4...)
    |     |___|
    |     | 2 |    ___
    |     |   |   | 1 |
    |     |   |   |___|                <-   Stacked Chart (axys 1)
    |     |___|   | 2 |                     with Only few itens stacked are selected
    |     | 3 |   |   |
    |     |   |   |   |
    |----------------------------------

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Partial data versus total on the same chart

    yes, once you move the series to the secondary axis and change chart type try adding secondary horizontal axis
    Cheers
    Andy
    www.andypope.info

+ 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. [SOLVED] 3,000 Tables versus 3,000 Worksheets versus 3,000 Workbooks
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 03:15 AM
  2. Replies: 1
    Last Post: 05-14-2006, 11:15 AM
  3. [SOLVED] Embedded Chart Versus Chart - ShowDetail Issue
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2006, 11:15 AM
  4. Post-versus Pre-surveys scatter plot chart
    By DSR in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2005, 09:40 PM
  5. [SOLVED] Chart versus Work Sheet Code Failure
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2005, 01:06 PM

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