dynamic data formatting question.

[Hui]

Mecheng


The name doesn't need the workbook name

Try just using : Acceptstream


When you go to add the data to a chart you need to use the sheet and Named Formula name

eg: 'Formated Data'!Acceptstream

 

[MechEng]

Thanks Hui!


Well it accepts the name for the range now but I'm still having difficulty graphing the range.


I created a name for the range in column A using the same method, as the chart is a graph of A against E and both ranges must be dynamic.

I called the range for column A, Timestream and used =OFFSET('Formated Data'!$A$5,,,COUNT('Formated Data'!$A:$A))

for the refers to box


Following what Narayan said above, I clicked on the data series on the chart, the series formula appears in the formula bar as

=SERIES("Accept",'Formated Data'!$A$5:$A$26,'Formated Data'!$E$5:$E$26,1)


I changed this to

=SERIES("Accept",timestream,acceptstream,1)


This gave another error.


http://i1101.photobucket.com/albums/g434/deco_r/screenshot2.jpg


Thanks so much for all your help everyone!

 

[Hui]

Select the Chart and right click

Select Data

Use the Select Data dialog

Select teh appropriate series

For the X Values enter ='Formated Data'!timestream

For the Y Values enter ='Formated Data'!acceptstream

 

[MechEng]

Thank you so much! That works perfectly! You ledgend! :D

 

[Montrey]

Glad we could help!!