Adding an Average line (from data sheet) to a chart automatically.
Jon, my friend...you still there? :)
My charts look FANTASTIC. Thank you.
Now, I've got Fiscal Month averages calculated and (as you probably know) by
dividing that total by 12, I have a monthly average for the year. Is there a
way to pull that calculated cell and have a horizontal line add itself based
on that data, and label itself "Monthly Average?" I'd like it to place
itself, and that way, I don't have to place it manually.
Also, I'd like to add another total to the chart from a cell in my data
sheet. I'd like to have a Total Hours (for the year) calculate and populate
a box on the chart.
Can you help again? Thanks so much!
|