PDA

View Full Version : Bars expanding beyond plot area when printing



HenrikJS
2013-08-01, 04:09 PM
Hi all, I'm having some serious difficulties with a bar chart I created, depicting project phases. I'm sorry if I use the wrong terms, I don't use excel with English settings.

The problem is that when I print it, the bars expand beyond the plot area, which interferes with the category axis (the project names) and frankly just makes the chart look confusing and ugly. I've tried everything to try to block out the expanded bars and limit them to just the plot area, but nothing seems to work. When I work with the chart in excel, there's no issue, but as soon as I go into print preview, the bars show up outside of the plot area. I've searched for solutions, but can't seem to find any.

I've attached the file in question to this post, hoping that one of you gurus can help me!

HenrikJS
2013-08-02, 10:55 AM
I fixed it myself by manually changing all dates before 01-01-2013 (where the plot area starts) to that date. Thread can be locked or deleted