Change the data range for Excel chart

Posted on 2014-09-02
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

    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 47

    Assisted Solution


    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

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

    Expert Comment

    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

    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

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now