chart in excel 2003 with vba
Posted on 2012-03-28
I'm having trouble creating the a chart with this data:
A B C
date + time data
01.01.2012 12:00 12:00 456789
There are several sets of these data. Date and time is always unique, but time is repeating each day. Data consists out of numbers.
I need to have date only on the right side (legend entries), and time (which can be used from first or second column) on the x-axis. So the resulting chart would display for each day a data line.
This problem is how to extract the date only, second problem is how to put the time entries on the X axis?
What is the best way to do this in VBA without using pivot? I'm using Excel 2003.
Thanks in advance.