sheesh.katie
Registered User.
- Local time
- Today, 08:50
- Joined
- Aug 8, 2012
- Messages
- 10
Okay, here's a problem I have that I'm not really sure how to explain. I'm sure it's something simple that I'm missing.
I have created a pivot chart (from a query made specifically for the pivot chart) to show the pattern of each recycle station. There are calculated fields (the cubic yard, i.e. 300, times the amount - 2,4,6, or 8- equals x - the total weight) and they work great. The lines look nice and what not.
The problem is that on the vertical axis, the scale goes from -500 to 2500. The lowest number is only supposed to go to 0. I know you can specify this, but the line still goes below the 0 instead of hitting it. My boss thinks the reason could be because if its 313 (cubic yard) x 0 (amount) that it is making it calculate a negative. If you scroll over the line, though, it shows that the number is a 0.
How do I make it just hit the 0 line instead of being negatives? It's driving me crazy. Thanks!!!
I have created a pivot chart (from a query made specifically for the pivot chart) to show the pattern of each recycle station. There are calculated fields (the cubic yard, i.e. 300, times the amount - 2,4,6, or 8- equals x - the total weight) and they work great. The lines look nice and what not.
The problem is that on the vertical axis, the scale goes from -500 to 2500. The lowest number is only supposed to go to 0. I know you can specify this, but the line still goes below the 0 instead of hitting it. My boss thinks the reason could be because if its 313 (cubic yard) x 0 (amount) that it is making it calculate a negative. If you scroll over the line, though, it shows that the number is a 0.
How do I make it just hit the 0 line instead of being negatives? It's driving me crazy. Thanks!!!
