Forum Discussion
Data trend line disappeared
tsaureI had a similar issue where I had trend lines on two graphs tied to separate pivot tables. I noticed one of them would occasionally lose the trend line as filtering occurred, but the other would not. I looked at the associated pivot tables and saw that the table associated with the graph that was losing its trend line had no column totals, while the other table did. I added column totals to the table and the trend line issue seems to have cleared itself up. Not sure why this would cause such a thing, but here we are.
daveahlman Thanks for the reply. I appreciate your response and solution. That is what happened to me as well. No idea what would cause one table to act differently from another, but as you said, here we are. Thanks again.