• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change the formula in the graph..

akinkaraman

akinkaraman

Member
=SERIES("ZFW";'Trim Sheet'!$T$15:$U$15;'Trim Sheet'!$P$15:$S$15;5)

I want it use 80000 instead of 'Trim Sheet'!$P$15:$S$15 if 'Trim Sheet'!$P$15:$S$15 is below 80000

How can I modify it?

Thanks in advance..
 
Hi ,

1. Create a named range , say Series1 , and in the Refers To box , enter the formula :

=IF('Trim Sheet'!$P$15:$S$15<80000,80000,'Trim Sheet'!$P$15:$S$15)

2. Modify your series formula as follows :

=SERIES("ZFW";'Trim Sheet'!$T$15:$U$15;'Trim Sheet'!Series1;5)

Narayan
 
So I need to use a new cell, and show that new cell in the graph.

Can any method solve this without using another cell?
 
Last edited:
Or
You can setup a dummy range on the worksheet
Then setups formula in the range to pick the values you want
Then change the range of the chart to look at the dummy range
 
You must log in or register to reply here.
Back
Top