# Getting the right chart legend

#### JenniferMurphy

##### Well-known Member
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.
 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?

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### Trouttrap2

##### Well-known Member
You can try this. First delete the cell contents in C3, meaning the R. Then highlight the C3:F14. That should put the X axis values found in C3:C14 and the series should be F=.5, F=1.0, F=2.0.

#### JenniferMurphy

##### Well-known Member
You can try this. First delete the cell contents in C3, meaning the R. Then highlight the C3:F14. That should put the X axis values found in C3:C14 and the series should be F=.5, F=1.0, F=2.0.

Wow, that worked. What's the rule? Am I not allowed to have a title over the X column? I kinda need it for when I paste the actual table in a document along with the graph.

Thanks very much.

#### JenniferMurphy

##### Well-known Member
PS: I just discovered that I can replace the "R" after the graph is created. So do I need to delete it just long enough to create the graph?

#### Trouttrap2

##### Well-known Member
Yes, you can put the R back. I should have said so. Anytime you are making a line chart Excel needs to know what the X axis is going to be. One quick way is leaving the Xaxis column header blank.

#### JenniferMurphy

##### Well-known Member
Yes, you can put the R back. I should have said so. Anytime you are making a line chart Excel needs to know what the X axis is going to be. One quick way is leaving the Xaxis column header blank.
It would be handy if Excel would assume that the first column is the independent variable and use the header as the variable name. In this case, it would become the R axis.

Replies
12
Views
114
Replies
2
Views
70
Replies
4
Views
254
Replies
7
Views
132
Replies
2
Views
269

### Forum statistics

1,126,931
Messages
5,621,661
Members
415,849
Latest member
PhoenixRising2015

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back