PDA

View Full Version : Help: Defined Array Formula In chart



yurble_vn
08-21-2007, 12:44 PM
HI All,

I'm trying to draw a chart which input is defined array formula

But i'm facing some trouble: when run the defined array formula seprately and then input chart by range. it works okie.

But when trying to put the defined array formula to chart. It does not work.

I also attached my file for your reference. Please do help

And also include here the file i base on:
http://oaltd.co.uk/DLCount/DLCount.asp?file=FunChrt5.zip

Bob Phillips
08-21-2007, 01:43 PM
Should you be using Series values like

=MatrixBar.xls!rngSer1

yurble_vn
08-21-2007, 08:18 PM
Thanks xld for prompt reply,

Yep, the very above chart is input as above. But it does not work.

Bob Phillips
08-22-2007, 12:03 AM
The version that I saw wasn't input like that.

So what does '... but it does not waork' mean? In what way?

yurble_vn
08-22-2007, 02:19 AM
Just download and check:

You can see, there are two charts in the attached file. The first right top conner one is input by defined name.

Please take a look at this pic:

http://img529.imageshack.us/img529/2963/illustratecl7.gif

Bob Phillips
08-22-2007, 03:16 AM
That is Stephen's file, noit yours.

yurble_vn
08-22-2007, 07:05 AM
Actually, I draw based on Stephen's technic. In Stephen's file,(as link) there is only bar chart with variable width. And in attached file, i try to draw matrix bar chart based on the same technic.

If it make any confusion, please kindly be apologized about that.

Please do take a look again on attached file, I do make some changes in:
1.rngBins
2.rngCost
3.rngSer1 -> rngSer3

Manually -> work
When use these defined array formula in excel sheet to calculate the Chart Data and then point chart data to it. It works well

Put defined name into chart --> not work
When use the same defined array formula, and put it into chart value. It does not work. As you can see in above image (the top-right chart), it just show 1 bar instead of hundreds bars

Please do help. I'm very newbie in this, so forgive if there is any technic-related stupid thing that i have exposed