Home |
Search |
Today's Posts |
#1
|
|||
|
|||
line graph drops when zeros
Hello, I have a set of data, basically this years data and last years data broken out by 52 weeks. Of course I have all of last years 52 weeks of data however this year I only have up to 26 weeks. I made a 2 line graph over 52 weeks this year vs. last year. Each cell either has a number or a zero (zero due to no data past this years week 26). Since there are zero's, it drops the line chart to the zero marker on the graph. How do you make it so that the line "just" stops where it see's the zeros. Please note that the cells that are referenced have "SUMIF" formulas in there linked to a master raw data sheet. The notion here is never have to update the graph sheet....just have it automatically update as the raw data is updated. Please advise. -- Maxwell_5000 ------------------------------------------------------------------------ Maxwell_5000's Profile: http://www.excelforum.com/member.php...o&userid=23810 View this thread: http://www.excelforum.com/showthread...hreadid=383346 |
#2
|
|||
|
|||
Two solutions:
1) use a dynamic chart that automatically extends the range when you add data - interested, please let us know 2) in the blank cell enter =NA(), this displays as #N/A. As you get more data, overwrite the NA formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Maxwell_5000" wrote in message news:Maxwell_5000.1rerqc_1120082736.3022@excelforu m-nospam.com... Hello, I have a set of data, basically this years data and last years data broken out by 52 weeks. Of course I have all of last years 52 weeks of data however this year I only have up to 26 weeks. I made a 2 line graph over 52 weeks this year vs. last year. Each cell either has a number or a zero (zero due to no data past this years week 26). Since there are zero's, it drops the line chart to the zero marker on the graph. How do you make it so that the line "just" stops where it see's the zeros. Please note that the cells that are referenced have "SUMIF" formulas in there linked to a master raw data sheet. The notion here is never have to update the graph sheet....just have it automatically update as the raw data is updated. Please advise. -- Maxwell_5000 ------------------------------------------------------------------------ Maxwell_5000's Profile: http://www.excelforum.com/member.php...o&userid=23810 View this thread: http://www.excelforum.com/showthread...hreadid=383346 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
is there a way to hide zeros in a line graph | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel | |||
IF formulas creates zeros in a line graph | Charts and Charting in Excel |