Change the data range for Excel chart

Posted on 2014-09-02
Medium Priority
Last Modified: 2014-09-07
Any idea how to change the data range for an Excel chart. I clicked the "Select Data" but it mentioned about the legend entries only. Any idea ?
Question by:AXISHK
LVL 19

Assisted Solution

helpfinder earned 400 total points
ID: 40297916
try with right click on your chart, choose Select data and in Chart data range you should have range the chart is using, edit it in a way you need to extend it.
LVL 54

Assisted Solution

Rgonzo1971 earned 400 total points
ID: 40297939

The Chart Data Range disappears as soon as the data is non contiguous or the data is resorted in the chart

to see the values used go on each serie and click Edit


Author Comment

ID: 40297998
Same, still see the same screen that I select before.
LVL 19

Expert Comment

ID: 40298031
try to select data range in your sheet and create new chart (the same as you have now, it does not matter, using Insert>Chart).
Then , if you still need, check Select data if you have range in field Chart data range
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1200 total points
ID: 40299652
AXISHK, in the dialog you posted in the screenshot, you need to click on one of the series in the list on the left and then click the Edit button. This will open a dialog where you can adjust the cell range for the series.

Another, easier, way to adjust the chart ranges is to click a column in the chart. You will then see the data in the sheet highlighted and you can drag the highlights with the corner handles to adjust the selection.


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question