|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-03-2005, 05:06 PM
|
|||
|
|||
|
Filter the way data is plotted
I have series of data that plots in a XY diagram. Is there a way to change
colour of the points plotted if a certain value is below a set value? e.g. one point turn red if A1 < 5? -- Regards Lars 
|
|
#2
05-03-2005, 07:06 PM
|
|||
|
|||
|
RE: Filter the way data is plotted
You can use two data series one for above your critical point and one for below
you can also select individual points and chage just the color of that point if there are only going to be a few points of interest. "Lars" wrote: > I have series of data that plots in a XY diagram. Is there a way to change > colour of the points plotted if a certain value is below a set value? e.g. > one point turn red if A1 < 5? > -- > Regards > Lars
|
|
#3
05-03-2005, 07:06 PM
|
|||
|
|||
|
Re: Filter the way data is plotted
Jon Peltier has instructions for conditional charts that you could adapt
to your workbook: http://www.peltiertech.com/Excel/Cha...html#CondChart Lars wrote: > I have series of data that plots in a XY diagram. Is there a way to change > colour of the points plotted if a certain value is below a set value? e.g. > one point turn red if A1 < 5? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#4
05-04-2005, 10:06 AM
|
|||
|
|||
|
RE: Filter the way data is plotted
Lars,
This example might help: http://www.pdbook.com/index.php/exce...scatter_chart/ ---------------------------- Regards, John Mansfield http://www.pdbook.com "Lars" wrote: > I have series of data that plots in a XY diagram. Is there a way to change > colour of the points plotted if a certain value is below a set value? e.g. > one point turn red if A1 < 5? > -- > Regards > Lars
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
