JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,491
- Office Version
- 365
- Platform
- Windows
I have a table of proficiency ratings (0-1) showing how they can be converted to an inverse scale with a damping factor. The headers in Row 3 show the factors.
<tbody>
</tbody>
I want to graph this table to show a line for each column (D, E, F). If I select C4:F14, I get the correct graph, but the legend labels are Series 1, Series 2, & Series 3.
If I select C3:F14, the graph is all screwed up. The X axis goes from 0 to 14, I assume because it takes Col B to be the X values, even though I didn't select it. The Y axis goes from -0.5 to 2.5, I assume because it takes Row 3 as data. And the legend still says Series 1 to Series 4.
The actual data in D3:F3 is 0.5, 1.0, & 2.0. The headers are generated using a custom format. This allows me to use those cells in the formulas below. But even it I get rid of the custom formats and just have the numbers in those cells, the graph looks the same including the legend.
Is there a way to get a graph that uses Row 3 as the labels, Col C (C4:C14) as the X values and Cols DEF as the Y values?
PS: I would post the graphs themselves, but I don't know how to do that without saving then to a file and then uploading that to Dropbox or somewhere? Why can't I just paste an image?
C/R | C | D | E | F |
3 | R | F=0.5 | F=1.0 | F=2.0 |
4 | 1.00 | 0.00 | 0.00 | 0.00 |
5 | 0.90 | 0.32 | 0.10 | 0.01 |
6 | 0.80 | 0.45 | 0.20 | 0.04 |
7 | 0.70 | 0.55 | 0.30 | 0.09 |
8 | 0.60 | 0.63 | 0.40 | 0.16 |
9 | 0.50 | 0.71 | 0.50 | 0.25 |
10 | 0.40 | 0.77 | 0.60 | 0.36 |
11 | 0.30 | 0.84 | 0.70 | 0.49 |
12 | 0.20 | 0.89 | 0.80 | 0.64 |
13 | 0.10 | 0.95 | 0.90 | 0.81 |
14 | 0.00 | 1.00 | 1.00 | 1.00 |
<tbody>
</tbody>
I want to graph this table to show a line for each column (D, E, F). If I select C4:F14, I get the correct graph, but the legend labels are Series 1, Series 2, & Series 3.
If I select C3:F14, the graph is all screwed up. The X axis goes from 0 to 14, I assume because it takes Col B to be the X values, even though I didn't select it. The Y axis goes from -0.5 to 2.5, I assume because it takes Row 3 as data. And the legend still says Series 1 to Series 4.
The actual data in D3:F3 is 0.5, 1.0, & 2.0. The headers are generated using a custom format. This allows me to use those cells in the formulas below. But even it I get rid of the custom formats and just have the numbers in those cells, the graph looks the same including the legend.
Is there a way to get a graph that uses Row 3 as the labels, Col C (C4:C14) as the X values and Cols DEF as the Y values?
PS: I would post the graphs themselves, but I don't know how to do that without saving then to a file and then uploading that to Dropbox or somewhere? Why can't I just paste an image?