Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trend line on two-axis graph | Charts and Charting in Excel | |||
Line graph showing '0' points | Charts and Charting in Excel | |||
How do I add a trend line for only half of my graph? | Charts and Charting in Excel | |||
Showing data as spreadsheet and a line graph. | New Users to Excel | |||
charting a single bar graph on one line showing continuous info | Charts and Charting in Excel |