ncgloryholes
welcome to my space
Home

Solved: Pushing the limit of multiple formats in charts....

January 6th, 2009 by jane
  • Morning All.

    I have, with help from this forum in the past, mastered the art of having a bar chart and a line chart in one.

    However, some bright spark has requested that my bar chart (two series of data) actually shows more information, by way of two stacked columns.

    Can a chart be created, which shows two or more multiple stacks of columns?
    (ie two stack columns for jan, two for feb etc)?

    I have searched for this, but with no success!!

    Thanks for any assistance - I expect that this will either be easy or not possible!!!:bye:


  • Hi there. Thanks Shades for your continued interest!!

    I have taken my spreadsheet, and made it anonymous ( formerly contained some sensitive info).

    I've also after about 4 hours of trying got the html maker add-in to work - hooray!

    Microsoft Excel - New page from monthly figures EXAMPLE.xls___Running: xl2002 XP : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    3
    		 2006 Prod A2006 Prod B2007 Prod A2007 Prod B2007 ForecastCumulative 06Cumulative 0707/06 as a %Cumulative %
    4
    		               200                210        
    5
    		 Jan                 220               220                 410               440 107%107%
    6
    		     0    
    7
    		                190                210        
    8
    		 Feb                 220               230                 810               890 113%110%
    9
    		     0    
    10
    		                170                160        
    11
    		 Mar                  180               200              1,140            1,270 115%111%
    12
    		     0    
    13
    		                190               200        
    14
    		 Apr                 220               230             1,530            1,720 115%112%
    15
    		     0    
    16
    		               200               200        
    17
    		 May                 300               230             1,930           2,250 133%117%
    18
    		     0    
    19
    		                210               220        
    20
    		 Jun                 260               280            2,360           2,790 126%118%
    21
    		     0    
    22
    		               250               260        
    23
    		 Jul                2,870           2,790 0%97%
    24
    		     660    
    25
    		               250               280    
    #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Solved: Pushing the limit of multiple formats in charts.... , Please add it free.

    • Posted in ncgloryholes.com | edit

    Cycling Idol Faced With More Doping Allegations Los Angeles, Ca - Home and Garden


    Categories


    Archives


    Blogroll



    Meta