LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 54
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
adding data series automatically mbk6784 Charts and Charting in Excel 0 June 9th 06 04:56 AM
can entered data in sheet 1 be automatically pasted in sheet 2 Adnan Jahangir Excel Discussion (Misc queries) 1 February 23rd 06 10:06 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"