hi all.

i am making a chart to plot my solar charge rates everyday that i enter them.

i have gottent the char to auto expand by referencing it to a table (after alot of messing around) and my axis are serup as

X (horizontal, i think) is the DATE
and there is a primary and secondary Y axis labeled Amphours and WattHours

but, i want it so that if i take a reading multiple times per day, then the x axis inserts it in the graph, but progresses it along if that makes sense.
currently, it just plots the points one above the other, i would rather it curve.

but, as there is only around 8 good solar hours in a day, i would like the minor unit to be equal to 1/12th of the scale, and ignore the other 12hours of the day.

i hope that all makes sense.

also, i have no VBA experiance etc... just a basic/intermediate knowlege in excel.

Jason