# Formulas in charts?

#### jen_FPS

##### New Member
Hello, I'm creating a workbook that has all of the current sales guys' total sales & profit for 2007 vs 2006. Each guy has their own chart with the dollar totals, and I'm trying to make a chart that has each guys' growth over last year.

I have the formula as a simple "=P34-B34" where as P34 is 2007 profit %, and B34 is 2006 profit%., to find the difference between the 2 years. Since August - December 2007 hasn't happened yet, it is taking 0 (blank cell) and subtracting 31, to get a -31% change over last year, only because the cell is blank. How can I chart them without the values being negative?

Is there any way to make this work?

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Replies
2
Views
519
Replies
14
Views
529
Replies
17
Views
617
Replies
0
Views
358
Replies
3
Views
927

1,191,354
Messages
5,986,173
Members
440,008
Latest member
Cmbuck

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back