Updating Graphs

Hello again

I have created a series of numbers using a column 'n' and 3 cells for Start value, End value and increment, this is thwe formula:

Please Login or Register  to view this content.

Where L8 is start value, C8 is 'n', O8 is increment and N8 is end value.

This is fine if i want whole numbers or predefine amounts of decimals, however now i wish to generate a list of values (angular) between 0 and 2pi radians (basically 0-360 degrees but in radians) how do i alter my formula to show the decimals?
I want to be able to calculate different increments so that needs to stay, any ideas?

Thanks

Max

Re-opened topic look below please

Again ive made a mistake... please read on :P

Can you post an example workbook so we can see your layout and what you want to achieve? Use "Manage Attachments" to post a workbook.

As you can see ive had to set the graph axis values to those in my sheet, i would like to select the entire line of data even the empty cells...


EDIT: excuse the weird titles, my lecturers idea of a joke :P

I basically want the graphs to auto update when i change the input variables without having to change the graph range.

Change the formula in D8 to

=IF(($L$8+(C8-1)*$N$8)>$M$8,NA(),($L$8+(C8-1)*$N$8))

You can then adjust the chart series to include all rows up to 607.

By using the "" previously it was forcing the numeric x axis to be treated as category, due to the text within numeric data.