Excel Tip - Add Additional Information To Your Excel Charts

 A number of occasions when you create your chart in Excel, you could need to add, change and even take away information from it. Excel makes it very easy to do that in plenty of methods.

There are basically 4 methods so as to add or change the info in your chart. You are able to do it immediately within the supply information by altering the cell vary, drag the vary handles, dragging information immediately onto your chart or copy and paste. All are very efficient and this text will discover all choices.

1. Change the cell vary that the chart relies on

• Choose the chart sheet or embedded chart you need to change
• Hit Chart Menu then Supply Information
• On the Information Vary Tab make certain your complete reference is chosen
• In your worksheet choose the vary of cells

In the event you want the row and column labels then guarantee they're included in your choice.

2. Drag the scale of the vary handles (this works should you created an embedded chart from adjoining worksheet cells, the chart nonetheless does have to be on the identical worksheet as the info used to create it).

• On the worksheet, kind the info and labels that you just need to add to the chart in cells which might be adjoining to the present worksheet information.
• Click on the chart to show the sizing handles across the supply information on the worksheet.
• On the worksheet, do one of many following
• So as to add new classes and information collection to the chart, drag a blue sizing deal with to incorporate the brand new information and labels within the rectangle.
• So as to add new information collection solely, drag a inexperienced sizing deal with to incorporate the brand new information and labels within the rectangle.
• So as to add new classes and information factors, drag a purple sizing deal with to incorporate the brand new information and classes within the rectangle

3. Add information by dragging (once more this chart should be on the identical worksheet as your information).

• On the worksheet simply choose the adjoining cells or ranges that comprise your information so as to add
• Level to the border of your choice
• Drag your choice immediately onto the chart
• Use the Paste Particular possibility and choice the choices it's good to plot extra data to your chart
• In the event you can't drag the choice make certain the Enable cell drag and drop field is chosen on the Edit Tab of the Choices dialog field

4. Copy additional information onto your chart

When you've got an embedded chart that's not on the identical worksheet as your information, you possibly can really simply copy and paste additional information into your chart.

• On the worksheet that incorporates your information choose the info vary you need to add into your chart
• Hit Copy
• Click on the chart sheet or the embedded chart that you just need to add to
• Both Hit Paste or Paste Particular to pick out the choices you need

It's very easy to replace and alter your information choice in your charts. These are the 4 methods to replace charting ranges with out having to re-create charts from scratch.