Labelling Graphs Once Every N Amount of Minutes/Hours/Days

[camikhazi]

Hi guys,

So basically i have a large table of data that is constantly growing and a graph that is plotting the data in this table.

My table contains a date/time column that is attached to the x-axis and 5 profit columns that are all plotted on the y-axis

I would like to plot some labels on my graph and i thought it would be cool if i could get it to plot the value of each profit just once every day.

The issue is, the date/time column in my table isnt regular - sometimes it plots values every 2 minutes, and sometimes values are absent for hours and days at a time.

Is there a way to do this?

Thanks,
Cam

[MrShorty]

Short but useless answer -- Yes, I'm sure there is a way to do this. I'm not sure there is enough information in your post to provide a more useful solution.

As I see it, you have data with 0 to n entries for each day. You want to analyze the data so that there is 1 entry per day. I would expect a process like this:

1) Create a column that lists the days of interest.
2) For days that have more than 1 entry, choose a value that represents that day.
3) For days that do not have an entry, use the surrounding days to choose a value for that day
4) Use these "helper columns" to create the chart.

[camikhazi]

Yeah that is exactly the kind of thing i am looking for!

Really not sure where to start with the coding though....

[MrShorty]

Having broken the problem down into steps, I would probably start with step 1 -- fill a column with the dates of interest.

You could try a technique like this: http://www.excelforum.com/excel-gene...ml#post4303128
Or enter the starting date in the 1st cell of this column, then use a formula like =E2+1 and copy down.