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
Bookmarks