Forum Discussion
Solved
Excel Graphs
I have attached the workbook I am needing help with. So, I have a graph that I need 2022 and 2021 data. However, I want the 2021 lines to add like you would 2022. What I mean by that is, for 2022 I ...
catherine9910 Perhaps like in the attached file?
Just add another data series for 2021 that copies the values if the value for 2022 is not empty.
By the way, I removed the formula in A1 on both sheets as they cause circular reference errors.
catherine9910 Perhaps like in the attached file?
Just add another data series for 2021 that copies the values if the value for 2022 is not empty.
By the way, I removed the formula in A1 on both sheets as they cause circular reference errors.
Awesome thank you!