Zoom Over Line Chart (1 Viewer)

Status
Not open for further replies.

ChrisO

Registered User.
Local time
Tomorrow, 05:20
Joined
Apr 30, 2003
Messages
3,202
Zoom Over Line Chart.

Rationale:-
Line charts can have too much data displayed in them to the point that they become almost useless. With this demo we can drag, drop and resize a Zoom Box, over the main chart, to show the zoomed detail of the main chart in another detail chart.



Note:-
There are no date/time fields in this demo. Each date/time is handled directly as an IEEE double, which is exactly what it is. The reason for this is that from Access versions 97 to 2003, charts do not appear to handle Afrikaans regional settings all that well. With Afrikaans, charts draw pre-noon plots in a most peculiar way. Using the IEEE double directly solves that problem.

Since the stored data type is an IEEE double the field data type can be changed to Date/Time if you like. There will be no loss of data going either way, IEEE <> Date/Time, but you may see a retrace anomaly in the chart with Date/Time when using Afrikaans regional settings.

Tested with:-
Version..............: Access 2003 (Access 2000 file format).
Regional settings.: Afrikaans, English, French, German and Portuguese.
References.........: None.
Error handling.....: Global but turned off in the demo for testing.
Close On Error…...: Turned on but will only happen if error handling is turned on.

If you have any questions, please ask them in the appropriate Forum.

Version 1.1
Some refactoring of the code.

Version 1
Original post.

Chris.
 

Attachments

  • A Screenshot.jpg
    A Screenshot.jpg
    96.4 KB · Views: 2,171
  • ZoomChart_A2003.zip
    106.3 KB · Views: 1,053
Last edited:
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom