| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formula for Graphs
This worked perfectly....thank you for your help!
"Bernard Liengme" wrote: Let's say you chart uses x-values starting in A2 and y-values starting in B2 Right now you are adding values to the end of the A and B columns Begin by copying the y-values (say B2:B100) to C2:C100 In B2 enter =MIN(500, C2) and copy this down the column Now you chart plots the old y-values if below 500, or it plots 500 When you want to add more data, enter the x-value at the end of A and the y-value at the end of C You may need to copy the formula in B down one row as you go. If this works for you, we can make some improvements. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Amber" wrote in message ... I have a graph that automatically updates each time a new X and Y value are entered. I would like to know if there is a way to put a formula in for my Y values so that if the value entered is over 500, the graph will plot 500 and not the actual number entered. Is this possible? Thanks.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP WITH GRAPHS | Excel Discussion (Misc queries) | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
| Bar Graphs | Charts and Charting in Excel | |||
| Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Threaded Mode
