| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart point colours to show time trend
Is there any way that I can plot two sets of data against each other, while
getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... |
|
#2
|
|||
|
|||
|
Hi,
See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Yes, but what I want is to show say change in price against change in volume
(for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
The conditional approach will work but it would require quite a few
helper columns. Another way would be via VBA. do you have data about the age of each point in another column or are the points within the column already in age order? AndyE wrote: Yes, but what I want is to show say change in price against change in volume (for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
They're in date order, with the dates next to them (so both!).
"Andy Pope" wrote: The conditional approach will work but it would require quite a few helper columns. Another way would be via VBA. do you have data about the age of each point in another column or are the points within the column already in age order? AndyE wrote: Yes, but what I want is to show say change in price against change in volume (for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
|
|||
|
|||
|
Here is a worked up example.
http://www.andypope.info/charts/spectrum.htm Cheers Andy AndyE wrote: They're in date order, with the dates next to them (so both!). "Andy Pope" wrote: The conditional approach will work but it would require quite a few helper columns. Another way would be via VBA. do you have data about the age of each point in another column or are the points within the column already in age order? AndyE wrote: Yes, but what I want is to show say change in price against change in volume (for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
|
|||
|
|||
|
Great - that looks ideal (excel-lent?). Thanks for the help Andy!
"Andy Pope" wrote: Here is a worked up example. http://www.andypope.info/charts/spectrum.htm Cheers Andy AndyE wrote: They're in date order, with the dates next to them (so both!). "Andy Pope" wrote: The conditional approach will work but it would require quite a few helper columns. Another way would be via VBA. do you have data about the age of each point in another column or are the points within the column already in age order? AndyE wrote: Yes, but what I want is to show say change in price against change in volume (for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#8
|
|||
|
|||
|
You're welcome.
AndyE wrote: Great - that looks ideal (excel-lent?). Thanks for the help Andy! "Andy Pope" wrote: Here is a worked up example. http://www.andypope.info/charts/spectrum.htm Cheers Andy AndyE wrote: They're in date order, with the dates next to them (so both!). "Andy Pope" wrote: The conditional approach will work but it would require quite a few helper columns. Another way would be via VBA. do you have data about the age of each point in another column or are the points within the column already in age order? AndyE wrote: Yes, but what I want is to show say change in price against change in volume (for an example), over say 2 years, with the colour of the plot points progressing from e.g. blue to red (via magenta on the way) over the two years, so you can track the data over time. I've seen it done, but I think elsewhere (different system, quite possibly). It's a question of setting up a relatively slow progression in the colour changes... "Andy Pope" wrote: Hi, See Jon Peltier's example of conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy AndyE wrote: Is there any way that I can plot two sets of data against each other, while getting the colour to vary depending on how recent the data points are? I'm using a scatter graph to build up a pattern of the interaction between two variables, but it would be great to know where in the (now 900) data I currently am, and what the short-term trends are... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Timeline Chart? | Charts and Charting in Excel | |||
| How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
| hide column but show chart | Charts and Charting in Excel | |||
| On a scatter chart show two point have same value | Charts and Charting in Excel | |||
| Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) | |||
Linear Mode
