Hi, I have a graph attached and I want to change it so it doesn't show the zero values in the plotted lines on the graph, but I still want the axis to show all the weeks (Wk -13 to Wk 13). Anyone know how to do this?
Hi, I have a graph attached and I want to change it so it doesn't show the zero values in the plotted lines on the graph, but I still want the axis to show all the weeks (Wk -13 to Wk 13). Anyone know how to do this?
Like this maybe
HTH
Regards, Jeff
Replace 0 with =NA()
Never use Merged Cells in Excel
Thanks so much that worked!
You are very welcome. We are glad to help and thanks for the feedback![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks