thamestowers
New Member
- Joined
- Jun 8, 2014
- Messages
- 23
Good Morning,
And thank you in advance for your responses!!
I have a question, that has been challenging me for past couple of days, and I would like to know if it is possible.
In Excel, I am creating an 2-D Area graph out of 3 Tables in a same sheet.
Now, each Table has few rows, and each should have the same color in the graph.
Is it possible to automatically set, that for each Table in the sheet, the data in the Graph takes a different color?
For example:
Data from Table 1 should be green
Data from Table 2 should be red
Data from Table 3 should be blue
(I think it is easier with tables, but if it is better with Range, I can change it)
And thank you in advance for your responses!!
I have a question, that has been challenging me for past couple of days, and I would like to know if it is possible.
In Excel, I am creating an 2-D Area graph out of 3 Tables in a same sheet.
Now, each Table has few rows, and each should have the same color in the graph.
Is it possible to automatically set, that for each Table in the sheet, the data in the Graph takes a different color?
For example:
Data from Table 1 should be green
Data from Table 2 should be red
Data from Table 3 should be blue
(I think it is easier with tables, but if it is better with Range, I can change it)
