| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Graph
Hello,
Need help with a dynamic graph. I am using a defined names to automatically update a chart range but I want the number of horizontal data points to be fixed at say 10 data points. I want to truncate old data points and add the newest each time a new entry is made. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Graph
Hi,
This page describes the last 12 months. You should be able to modify for your needs. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Fay" wrote in message ... Hello, Need help with a dynamic graph. I am using a defined names to automatically update a chart range but I want the number of horizontal data points to be fixed at say 10 data points. I want to truncate old data points and add the newest each time a new entry is made. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Graph
Tons of ideas he
http://peltiertech.com/Excel/Charts/ChartIndex.html http://www.andypope.info/charts.htm HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Andy Pope" wrote: Hi, This page describes the last 12 months. You should be able to modify for your needs. http://peltiertech.com/Excel/Charts/DynamicLast12.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Fay" wrote in message ... Hello, Need help with a dynamic graph. I am using a defined names to automatically update a chart range but I want the number of horizontal data points to be fixed at say 10 data points. I want to truncate old data points and add the newest each time a new entry is made. Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
| Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
| Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
Linear Mode
