SOLVED

Excel Charts – Selecting Data

Copper Contributor

Hello, and good day,

 

As shown below, I have a chart with data selected for the X- and Y-axes. I want to manually add in '26' for an X value and '1318' for a Y value. For X, I just typed in 26 after the 4 in the braces. For Y, how do I do that when there is the cell selection stuff there?

 

Caelin_0-1697434540995.png

 

The below does not work correctly, and neither does rewriting it to be "...N$11), {1318}".

 

Caelin_1-1697434756668.png

 

Does what I am asking make sense?

 

Thanks for your help!

Caelin

 

 

3 Replies

@Caelin 

Enter the value 1318 in a cell, say Z11, and add the address of that cell within the parentheses:

=(Sheet1!$C$11,Sheet1!$E$11,...,Sheet1!$N$11,Sheet1!$Z$11)

@HansVogelaar 

 

I thought of that last night but I was hoping to get a different answer. Do you know of a way to insert the datum into the pop up box that I pictured? (I want a cleaner way to do it then how you suggested.)

best response confirmed by Caelin (Copper Contributor)
Solution

@Caelin 

Excel won't accept a mixture of cell references and literal values in the Series Values box, so I'm afraid you have to enter the value in a cell.

You could create named ranges:

HansVogelaar_0-1697483718659.png

Use these in the Select Data dialog for the chart:

HansVogelaar_1-1697483836174.png

If you want to add a value, you still have to do so in a cell, and expand the definition of the named ranges XValues and YValues, but the chart's data source will look a bit neater.

1 best response

Accepted Solutions
best response confirmed by Caelin (Copper Contributor)
Solution

@Caelin 

Excel won't accept a mixture of cell references and literal values in the Series Values box, so I'm afraid you have to enter the value in a cell.

You could create named ranges:

HansVogelaar_0-1697483718659.png

Use these in the Select Data dialog for the chart:

HansVogelaar_1-1697483836174.png

If you want to add a value, you still have to do so in a cell, and expand the definition of the named ranges XValues and YValues, but the chart's data source will look a bit neater.

View solution in original post