Good afternoon.
I have a problem and I could not find a way to reverse it.
I have a Table where the Rows range from 1 to 8 and the columns are A, B, C.
It turns out that A has value for all lines, but B only for Lines 1 and 2, and C for 3 to 8.
I can not make a chart of it.
I've done two different tables and excel does not understand me.
The problem is that the returned graph has a gap, referring to the values of B for lines 3 to 8 and of C for lines 1 and 2, which do not exist.
The images are shown below.
TL;DR: I want two columns facing each number (1 to 8), but with 2 different colors for the second column of each number.
1.PNG
2.PNG
3.PNG
Bookmarks