N
Nornny
Hi. I'm having a bit of a design problem with my charts. I have multipl
charts that graphs data for 13 consecutive months. However, I only hav
the first two months' data. My graphs (which are all line graphs) loo
like a single spike because all the lines plummet to 0 by the thir
month. I'm looking for a way to just cut off the graph before i
reaches the third month, and to have it do so every time I add anothe
month's data. The sudden falloff is incredibly inaccurate, but i don'
know how to get rid of it. Then again, I don't want a graph that onl
has two months, either. And I don't want to constantly change the rang
every time i get new data either.
My data tables are set up like so. The label for the 13 months are o
one row. In the first column is names of the vendors for which i'
collecting data. I hope that makes sense. The data is not manuall
inputted each month, but collected by referencing a separate extrac
worksheet in the workbook. So the data tables are a bunch of formulas
For the month's that don't exist, their worksheets are blank, and th
resulting effect on the data table is a bunch of 0's down the column
Essentially, how do I ignore those 0's until there's real data?
I want the graphs to show all 13 months still, keep in mind.
Thank you so much in advance for anyone that can help! I've been tryin
everything and searching like crazy
charts that graphs data for 13 consecutive months. However, I only hav
the first two months' data. My graphs (which are all line graphs) loo
like a single spike because all the lines plummet to 0 by the thir
month. I'm looking for a way to just cut off the graph before i
reaches the third month, and to have it do so every time I add anothe
month's data. The sudden falloff is incredibly inaccurate, but i don'
know how to get rid of it. Then again, I don't want a graph that onl
has two months, either. And I don't want to constantly change the rang
every time i get new data either.
My data tables are set up like so. The label for the 13 months are o
one row. In the first column is names of the vendors for which i'
collecting data. I hope that makes sense. The data is not manuall
inputted each month, but collected by referencing a separate extrac
worksheet in the workbook. So the data tables are a bunch of formulas
For the month's that don't exist, their worksheets are blank, and th
resulting effect on the data table is a bunch of 0's down the column
Essentially, how do I ignore those 0's until there's real data?
I want the graphs to show all 13 months still, keep in mind.
Thank you so much in advance for anyone that can help! I've been tryin
everything and searching like crazy