If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use ofname in a Carts
I like tu give a range a name and the use it as source
data fore a Charts. That way i can control de data that is shown in the cart EX. I mak a car from the data in area A1:E20. Then I name the area 'DATA'. Insted of using the Area A1:E20 I use 'Data'. Then if the area change to A1:E20 I just change the name 'Data' from A120 to A1:d22 |
#2
|
|||
|
|||
In step 2 of the chart wizard, or using Source Data from the Chart menu
for an existing chart, click on the series tab. For the Values, X Values, and Name, you can enter a defined range name instead of an address. You must insert the name of the sheet before the range name, the same as for a range address: =Sheet1!$A$1:$A$20 becomes =Sheet1!NameOfXDataRange You have used a single name for the entire data range. To use names in a chart, you need to define a name for the X and Y values (and name if you're using it) for each series. You have set up the basics for dynamic charts, which in conjunction with dynamic range formulas, allow a chart to change the size of its data range when that changes. Here's some examples and links, if you're interested: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Korsholm wrote: I like tu give a range a name and the use it as source data fore a Charts. That way i can control de data that is shown in the cart EX. I mak a car from the data in area A1:E20. Then I name the area 'DATA'. Insted of using the Area A1:E20 I use 'Data'. Then if the area change to A1:E20 I just change the name 'Data' from A120 to A1:d22 |
#3
|
|||
|
|||
For a short write up on how to use names with new and existing charts
see Names in Charts http://www.tushar- mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I like tu give a range a name and the use it as source data fore a Charts. That way i can control de data that is shown in the cart EX. I mak a car from the data in area A1:E20. Then I name the area 'DATA'. Insted of using the Area A1:E20 I use 'Data'. Then if the area change to A1:E20 I just change the name 'Data' from A120 to A1:d22 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line Carts | Jennifer | Charts and Charting | 1 | May 25th, 2004 10:50 PM |