Forum Discussion
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.
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)
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.)
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.
