Hello.
I need some help
I have copied a chart from one sheet to the other and i am wondering if it is possible that when i change color, size,... of the original chart, that the other (copied) chart would also change?
Also I have a column chart and I want the last column to always be the same color (and different than the other columns), even when i add new data. Now i change color manually and when i add new data and new column appears, it shifts and penultimate column changes to that color, and the last column is the same as the other columns.
I hope you know what i mean, I don't know how to explain + English isn't my first language
Thank you for help.
I need some help
I have copied a chart from one sheet to the other and i am wondering if it is possible that when i change color, size,... of the original chart, that the other (copied) chart would also change?
Also I have a column chart and I want the last column to always be the same color (and different than the other columns), even when i add new data. Now i change color manually and when i add new data and new column appears, it shifts and penultimate column changes to that color, and the last column is the same as the other columns.
I hope you know what i mean, I don't know how to explain + English isn't my first language
Thank you for help.