SOLVED

# Excel Charts – Selecting Data

Copper Contributor

# Excel Charts – Selecting Data

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?

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

Does what I am asking make sense?

Caelin

3 Replies

# Re: Excel Charts – Selecting Data

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)

# Re: Excel Charts – Selecting Data

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

# Re: Excel Charts – Selecting Data

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:

Use these in the Select Data dialog for the chart:

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

# Re: Excel Charts – Selecting Data

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:

Use these in the Select Data dialog for the chart:

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.