extra points on graph

[Tim_C.]

Hello

I have a set of data in two colums

Col 1 = date in M/D/Y format

Col 2 = Data (numbers)

I have the XY graph plotting the data according to the date but as I zoom in and out I notice weekend dates are showing up

the data was only taken during the week.

When I review the array that is sent to the time conversion FOR LOOP it does not show any weekend dates.

Are these dates showing up because of the way the XY Graph handles the different Zoom levels as the date is fed into it in the UTC format

I would really like to be able to:

1. Get rid of the extra dates

2.  Be able to have booleans or runtime shortcut menu toggle different zoom levels such as daily, weekly, monthly, etc,,,,,

Any suggesstions would be appreciated

Tim C.

[Tim_C.]

Added a control to see if a sunday date was being generated via the UTC function

And there does appear to be weekend dates being generated

Does anyone know why these weekend dates would be generated from a UTC funtion if a weekend date is never fed to it?

Thanks

Tim C.

[Tim_C.]

I forgot to attach the code I have been woking with...

I use the open text file to work with the date as a string and I use the read spreadsheet file so I can work with data as nubers

Thanks again

Tim C.

[Tim_C.]

I worked on the code some more to get the basis for zooming the XY graph

I also toggled the Date/Time to second function UTC parameter and noticed that I could get the weekend dates in seconds to

no be included in the array sent to the XY graph but the weekend days still show up on the X axis.

Is the anyway to make the weekend dates not show up on the x axis?

Thanks

Tim C.

[TCPlomp]

You mean skip these dates?
like:
Mon   Tues    Wed   Thurs   Frid   Mon

I don't think so.
What you could do is remove the text formatting from the axis. Subtract two days for evere week from the data (week 1 no subtraction, week 2 2 days, week 3 4 days and so on) and create a picture (transparant background, with the days in them and place these over the axis) positioning this might be difficult but it should be possible. You even can create the dates in them.

succes,

Ton