PivotChart Axis fail

[drag0n_45]

Hey there everyone,
I'm trying to make a pivotchart to display a summary of data from some of our plants. The problem I have is when I filter a field, one gridline goes way up to the top (beyond the top of the chart area). It's weird, and I can't figure out why it happens. It always seems to be with the same axis as well. Any ideas?

the only thing I can think of is that there's some data somewhere that's not in the filtered range that causes it to display like that, but it only does it on with some locations, not all.




EDIT: Not sure what significance this has yet, but the only values that appear over the top like that are 2E-13 and 8E-14. Various totals don't do this.

[BillBoeBaggins]

Can you make the numbers more reasonable? You know how much you look at census data they don't show 42,000,000 they will show it as 42 stating that the number represents millions. That would be a step in making this easier to read. But lets move on to the issue.

It sounds like the Pivotchart cannot scale to where it needs too, do you have max values set for the axis?

[drag0n_45]

I could make the numbers more reasonable, but that would make them inaccurate. The numbers can vary by multiple decades, and are variable based on which plant I select (the filter field). That's why I used scientific notation.

Both the max and min values are set to automatic.

[drag0n_45]

I hate to be a bumper, but this is kind of an important issue - does anyone have any ideas? :/

[Siddharth Rout]

Upload your workbook... Will check it out this weekend.

[drag0n_45]

It's got linked tables. Your queries won't work. The workbook is about 26M in size also, and is being used as a temporary solution until I can hit up SQL. I'm not sure show to freeze a workbook (if it's even possible), so that the data there is whats used and the source isn't accessed in the linked tables.