Hello,
When I copy a graph on the dashboard it keeps the same formats (color scheme, grid lines, etc.), however when I change the data I want to look at it completely reverts back to defaults even if the data is the same # of cells and the same type of cells. Is there any way to keep the same formats but change the data being looked at?
In the exact example I have a series of 12 cells all in the same row that I'm pulling from into a chart; and, when I want to create a new graph, I just need to grab the data from the 12 cells underneath the previous data set and create a graph with that data. So when I copy the previous data's graph everything looks great, but when I change the data being grabbed by hitting the "Edit Data" button it will then automatically revert to defaults.
Thank you for your help,
-Chris