Graph Template X Y Axis by uwg12118

VIEWS: 518 PAGES: 16

More Info
									Waterfall Charts Macro
Your paypal email

Registration code                                            ERR




Chart Control Options                                               Waterfall Charts Macro
X Axis Font Size                                               11   Excelx2.com 23.6.2006
Maximum:                                                            admin@excelx2.com
Minimum:
Background Colour                                                   Instructions:
Chart Title                              Enter your title here !         1) Select Source Data (in the example from B21 to
Other Options                                                            2) If the range selected is invalid, a dialog box show
              TRUE                    Draw Lines                         3) Press OK and modify your graph as desired (ava
              TRUE                    Draw Overview Arrows               4) If you want to protect your data, you can convert


                                     Main Column Colour
    Enable Conditional Format
                                     Positive Delta Colour
              TRUE                   Negative Delta Colour          Modifying the graph settings
                                                                         1) The chart starts with a full column, then shows in


CHART DATA
                                                                         2) The colour of the columns is selected automatica
Main Column 1                   50
Delta 1                         40                                       3) You can select some options for your graph in th
Delta 2                         30
Middle Column                   120
Delta 3                         10
Delta4                          20
Delta 5                         -50
End Value                       100




                                                                         NOTE:
Waterfall Charts Macro
Excelx2.com 23.6.2006
admin@excelx2.com

Instructions:
     1) Select Source Data (in the example from B21 to C28), and press the Create Waterfall Chart button
     2) If the range selected is invalid, a dialog box shows, that allows you to select again the cells with the graph data
     3) Press OK and modify your graph as desired (available for registered users)
     4) If you want to protect your data, you can convert the chart into a picture (press above button after 1),2) and 3))




Modifying the graph settings
     1) The chart starts with a full column, then shows incremental changes, until a formula is encountered.
            (usually a subtotal) at which point another full column is charted.


     2) The colour of the columns is selected automatically, unless you enable conditional formatting, or override it by painting the text cells with your de


     3) You can select some options for your graph in the Graph Control Options Area:


            X Axis Font Size: Size for the X Axis text
            Minimum: It cuts the main columns at this value. This is useful to scale the graph, so that you can see your deltas properly
            Maximum: Maximum value for the Y Axe. If empty, it is automatically selected (recommended)
            Background Colour: Color used for the background of the graph
            Chart Title: Title
            Draw Lines: Draws lines between columns
            Draw Overview Arrows: Draws Arrows with absolute deltas from main column to main column


            The graph will not be updated automatically if you change the colours or the numbers.
            You have to generate a new chart (just press the button again)
            Known issue: The lines between columns for negative values have to be adjusted manually
            IN DEMO MODE: You can delete the generated chart, enter other values and settings, and generate as many charts as you want
            Once you register, you will be able to keep and modify the original excel chart
 it by painting the text cells with your desired colour (e.g. B28)




ee your deltas properly




as many charts as you want
  0     0   0
  0     0   0
 50     0   0
 90    50   0
 50     0   0
 90    50   0
120    90   0
120     0   0
130   120   0
150   130   0
150   100   0
100     0   0

								
To top