Home |
Search |
Today's Posts |
#1
|
|||
|
|||
scatter charts
Hi,
I am trying to create a simple scatter graph. The thing is, the requestor wants the data markers to vary, based on a 3rd value. Is there a way to do this? Any help would be appreciated. Thanks, Scott |
#2
|
|||
|
|||
The easiest is to use an add-in such as Rob Bovey's XY Chartlabeler
(www.appspro.com) or John Walkenbach's Chart Tools (www.j-walk.com). To do the task by hand, see Data Labels http://www.tushar-mehta.com/excel/ne...els/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, I am trying to create a simple scatter graph. The thing is, the requestor wants the data markers to vary, based on a 3rd value. Is there a way to do this? Any help would be appreciated. Thanks, Scott |
#3
|
|||
|
|||
one of the ways to do this is to use multiple data series with if statements
which woul deither use the value of the point or a value outside the plot range depending on the criteria. Then plot all of these secondary data sets and format the symbols as wanted for each criteria. "sroe9738" wrote: Hi, I am trying to create a simple scatter graph. The thing is, the requestor wants the data markers to vary, based on a 3rd value. Is there a way to do this? Any help would be appreciated. Thanks, Scott |
#4
|
|||
|
|||
PMFJI, but a few pictures is worth a few thousand words. This page
illustrates the technique bj has suggested: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bj wrote: one of the ways to do this is to use multiple data series with if statements which woul deither use the value of the point or a value outside the plot range depending on the criteria. Then plot all of these secondary data sets and format the symbols as wanted for each criteria. "sroe9738" wrote: Hi, I am trying to create a simple scatter graph. The thing is, the requestor wants the data markers to vary, based on a 3rd value. Is there a way to do this? Any help would be appreciated. Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter charts -- can I lock in a 1:1 aspect ratio for axes? | Charts and Charting in Excel | |||
Scatter Charts | Charts and Charting in Excel | |||
XY Scatter charts | Charts and Charting in Excel | |||
Can I use xy scatter charts to plot absolute measurements? | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel |