Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
xy scatter additional labels
Hi,
How about adding an additional series and using it's data labels to display the result of a formula which counts the number of doc's. The data labels can be linked to the cells using a free addin. Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) Cheers Andy dav363 wrote: 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:) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
xy scatter additional labels
On Tue, 23 May 2006, in microsoft.public.excel.charting,
dav363 said: 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. Normally the x axis categories come from a single row or column, but you are allowed to define a two row (or two column) range for the x-axis, so that one of them is the month, and the other is your percentage statistic. They should display one below the other. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |