line graph showing monthly trend
I have a spreadsheet that has tabs for every month jan, feb, mar etc.
Each month has data in it respective to that month, as it is only Jan obviously Feb - Dec will not have any data just the headers. My data starts at A8 in each month tab. I have a summary page that keeps a running total of specific data I am looking for. For example how many times there was an instance that we had the wrong address on file. Also on the summary page I have Line charts that show the monthly trend from january to december for each specific data we are looking for. In this example it would be wrong address, showing how many in january, february, march etc. My question is: Is there anyway to that i can display the graph and have the months without any data in it ignored. Currently I have to re-source the graph each new month. I would like to keep the source to show all the months but ignore the ones that do not have data in it yet. I can not ignore 0 entries, because there may be instance where the data is actually 0. |
line graph showing monthly trend
Sorry posted in wrong section by accident.
"AJ" wrote: I have a spreadsheet that has tabs for every month jan, feb, mar etc. Each month has data in it respective to that month, as it is only Jan obviously Feb - Dec will not have any data just the headers. My data starts at A8 in each month tab. I have a summary page that keeps a running total of specific data I am looking for. For example how many times there was an instance that we had the wrong address on file. Also on the summary page I have Line charts that show the monthly trend from january to december for each specific data we are looking for. In this example it would be wrong address, showing how many in january, february, march etc. My question is: Is there anyway to that i can display the graph and have the months without any data in it ignored. Currently I have to re-source the graph each new month. I would like to keep the source to show all the months but ignore the ones that do not have data in it yet. I can not ignore 0 entries, because there may be instance where the data is actually 0. |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com