LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
dav363
 
Posts: n/a
Default xy scatter additional labels


Hi,

I'm putting together a plot which shows the number of days taken to
complete documents against the date of completion. This is then
grouped per month. The purpose is to report number of documents in any
month which toook more than 15 days to complete. I've got a nice
looking scatter plot with a red line across the 15 day gridline so it's
quite easy to look above this line and count the number of late doc's in
any given month(there's only a handful each month). What I would like
to do is add to the chart a label under each month showing the
percentage of the total docs which took more than 15 days to complete.
Obviously this is easy enough to extract from the data on the
spreadsheet but is there any way of adding it to the chart so that I
can then cut and paste this into a report without having to also take a
section of spreadsheet showing the percentages.

Any suggestions are very welcome:)


--
dav363
------------------------------------------------------------------------
dav363's Profile: http://www.excelforum.com/member.php...o&userid=34696
View this thread: http://www.excelforum.com/showthread...hreadid=544625

 
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
Scatter Plot and Axes labels Baapi Charts and Charting in Excel 1 October 8th 05 03:57 PM
Labels for Scatter Diagrams ksn Charts and Charting in Excel 1 July 2nd 05 03:46 PM
How to assign datalabels to a scatter chart, obtaining the labels. Jos Koot Excel Discussion (Misc queries) 1 April 22nd 05 12:11 PM
Moving labels in a scatter plot Ian Belcher Charts and Charting in Excel 1 March 30th 05 10:24 PM
How do I add column A data labels to a scatter of columns B and C? Christina1 Charts and Charting in Excel 3 March 27th 05 03:43 AM


All times are GMT +1. The time now is 11:24 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"