Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter Plot and Axes labels | Charts and Charting in Excel | |||
Labels for Scatter Diagrams | Charts and Charting in Excel | |||
How to assign datalabels to a scatter chart, obtaining the labels. | Excel Discussion (Misc queries) | |||
Moving labels in a scatter plot | Charts and Charting in Excel | |||
How do I add column A data labels to a scatter of columns B and C? | Charts and Charting in Excel |