Hi evryone,
I couldn't find any help on this topic up to now.
I have to cells which contain the staring and end point (row number) based on which in other cells an adress is created. e.g:
Cell_A = 10
Cell_B = 20
Cell_C = Sheet!$A$10:$A$20
How can I reference the data of the chart to Cell_C? Is there any way to do so? I always get the message UNallowed reference or similar (mine is in German).
Thanks in advance for any help!
Cheers,
Lukas
Use:
=INDIRECT(Cell_C)
to get Excel to reference the data.
Hope this helps.
Pete
To base a chart on a range reference you will need to create a named range.
CHTDATA: =INDEX(Sheet1!$A:$A,Sheet1!$A$1):INDEX(Sheet1!$A:$A,Sheet1!$B$1)
Assuming A1 contains the starting point and B1 the end point.
The formula in C1 is not required.
Thanks for the fast help,
but neither seems to work. If I put either of the proposed options in the Y.values slot, it directs me to the correct part of data on the correspondig sheet. But as soon as I press Enter to accept, it keeps giving me the error message
Any advice?
PS: It should be an xy scatter plot with two measurements in each diagram with corresponding x and y values.
P1.jpg
Last edited by kadekl; 10-18-2012 at 08:34 AM. Reason: addition
A picture is not much use - post a sample workbook.
Pete
You can not use formula directly in the series data dialog.
You need to define named ranges and then reference the named ranges.
See revised example for xy-scatter
Here is a sample file:
based on the values in Cells E2 and E3 an adress is generated and should update the data in the diagram.
Cheers,
Lukas
Forum-Test.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kadekl 
Register To Reply
Bookmarks