Hi,
i have to plot the air temperature measured during many years 4 times per day.
as x-data i have to give the full date (dd/mm/yyyy hh:mm), but then i want that the chart just displays the year one time. If i change the format of x-axis as yyyy;@ i become the years 1900, 1901, ..., 1909, while my datas go from 2010 to 2012..
can someone help me?
Thanks a lot!
EDIT: i also have date and hour in separate columns (1 column for year, 1 for month, 1 for day, 1 for hour, 1 for minutes) but i collapsed all with vba because i thinked it was easier, isn't it?
i have to plot the air temperature measured during many years 4 times per day.
as x-data i have to give the full date (dd/mm/yyyy hh:mm), but then i want that the chart just displays the year one time. If i change the format of x-axis as yyyy;@ i become the years 1900, 1901, ..., 1909, while my datas go from 2010 to 2012..
can someone help me?
Thanks a lot!
EDIT: i also have date and hour in separate columns (1 column for year, 1 for month, 1 for day, 1 for hour, 1 for minutes) but i collapsed all with vba because i thinked it was easier, isn't it?
Last edited: