Chart Y-Labels are centered

[tomw1808]

After examining the charts, I guess you have a typo there:

PHPExcel/Writer/Excel2007/Chart.php

[...]

            if ($id1 > 0) {
                    $objWriter->startElement('c:crossAx');
                        $objWriter->writeAttribute('val', $id1);
- Line 624:                         $objWriter->writeAttribute('val', $id2);
+ Line 624:                         $objWriter->writeAttribute('val', $id1);
                $objWriter->endElement();

                    $objWriter->startElement('c:crosses');
                        $objWriter->writeAttribute('val', "autoZero");
                    $objWriter->endElement();

                    $objWriter->startElement('c:crossBetween');
                        $objWriter->writeAttribute('val', "midCat");
                    $objWriter->endElement();
            }
[...]

What happens is that Excel is cross-referencing the y-axix to the wrong and moving it to the center. No Idea why this happens only with negative numbers, but, hey, it solves the issue.

Great work by the way! Keep it up! :)

[tomw1808]

There is another problem with the c:crossBetween element. If it is set to "midCat" then the values will be shifted to the left, leaving a bar-chart with more than one value-set so far left-shifted that the first value will disappear.

set following
                        $objWriter->writeAttribute('val', "midCat");
to

                        $objWriter->writeAttribute('val', "between");

[kossak]

How does it work? Will something happen with this issue? It's still there, as in first report.