ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Range of data (https://www.excelbanter.com/excel-discussion-misc-queries/108428-range-data.html)

Ismael Jr

Range of data
 
Hi.
I need to change the data range that are plotted in my graphic. How can I do
this???
Thanks.

JLatham

Range of data
 
Right-click on the graphed area of the chart and choose [Source Data] then go
identify/choose the new data range to chart.

"Ismael Jr" wrote:

Hi.
I need to change the data range that are plotted in my graphic. How can I do
this???
Thanks.


Earl Kiosterud

Range of data
 
Ismael Jr.,

JLatham is exactly right about this. Also if the chart is on the sheet that
the cells are on, you can select the chart and you'll see colored reference
boxes around the cells. You can change these boxes by dragging either the
box lines, or the corners. It's the same as when a formula is in Edit mode.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JLatham" wrote in message
...
Right-click on the graphed area of the chart and choose [Source Data] then
go
identify/choose the new data range to chart.

"Ismael Jr" wrote:

Hi.
I need to change the data range that are plotted in my graphic. How can I
do
this???
Thanks.





All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com