Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollable x-axis in excel
I'm looking for a way to "zoom-in" my x-axis and rather than have all of the
data from a very large database displayed at once, be able to scroll (as in a data aquisition software screen) through it (day-by-day, etc) so as to see meaningful trends without having to regenerate a new chart when I need to switch days. I currently am using a 'lines on 2 axis' type of chart. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollable x-axis in excel
You want some kind of dynamic chart. I have some links and general examples
he http://peltiertech.com/Excel/Charts/Dynamics.html The example that might help the most is on this page: http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jea123" wrote in message ... I'm looking for a way to "zoom-in" my x-axis and rather than have all of the data from a very large database displayed at once, be able to scroll (as in a data aquisition software screen) through it (day-by-day, etc) so as to see meaningful trends without having to regenerate a new chart when I need to switch days. I currently am using a 'lines on 2 axis' type of chart. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollable x-axis in excel
Hi jea123,
For an old macro (with, I think an interesting approach) see 'Zoom Charts' at http://edferrero.m6.net/charting.aspx Ed Ferrero http://edferrero.m6.net/ I'm looking for a way to "zoom-in" my x-axis and rather than have all of the data from a very large database displayed at once, be able to scroll (as in a data aquisition software screen) through it (day-by-day, etc) so as to see meaningful trends without having to regenerate a new chart when I need to switch days. I currently am using a 'lines on 2 axis' type of chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
x axis cut off on an Excel 2002 scatter chart | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do I get a second Y axis in Excel 2000 | Charts and Charting in Excel |