Table to Chart w/linking cells that contain formulas

[Angel]

When I try to make a chart from the table that pulls its data from cells that have a formula to calculate its value it will not work correctly.

For example on my table cell DC!B3 contains“=ARP!B16” and cell ARP! B16 contains a formula. The cells in the table show the correct values and works dynamically but won’t allow me to format a chart.

If I build a table that is linking to cells that contain a hardcoded value when I go to create a chart it works fine…?

 

[NARAYANK991]

Hi ,

Is there any reason you have written your formulae , using text for numbers , as in :

=IF(B15>=$R$15,"5",IF(B15>=$Q$15,"4",IF(B15>=$P$15,"3",IF(B15<$P$15,"0"))))

Why not :

=IF(B15>=$R$15,5,IF(B15>=$Q$15,4,IF(B15>=$P$15,3,IF(B15<$P$15,0))))

Narayan

 

[Smallman]

Hi Angel

Welcome to Chandoo forum

Excel charts have genuine trouble plotting text as numbers. In M30 of the APR sheet change your forumula to

=IF(M29>=$R$29,"5",IF(M29>=$Q$29,"4",IF(M29>=$P$29,"3",IF(M29<$P$29,"0"))))*1

There you go, the chart on the Dec sheet now works.

Take care

Smallman

 

[Angel]

Hi ,

Is there any reason you have written your formulae , using text for numbers , as in :

=IF(B15>=$R$15,"5",IF(B15>=$Q$15,"4",IF(B15>=$P$15,"3",IF(B15<$P$15,"0"))))

Why not :

=IF(B15>=$R$15,5,IF(B15>=$Q$15,4,IF(B15>=$P$15,3,IF(B15<$P$15,0))))

Narayan

This a workbook that I inherited and I did not even notice that!
Took out the “ “ and it works great Thank you soooooo much!

 

[Angel]

Hi Angel

Welcome to Chandoo forum

Excel charts have genuine trouble plotting text as numbers. In M30 of the APR sheet change your forumula to

=IF(M29>=$R$29,"5",IF(M29>=$Q$29,"4",IF(M29>=$P$29,"3",IF(M29<$P$29,"0"))))*1

There you go, the chart on the Dec sheet now works.

Take care

Smallman

This a workbook that I inherited and I did not even notice that!
Took out the “ “ and it works great Thank you soooooo much!