If you’re lucky, all of your charts will be managed in Excel. If you have the unhappy task of dealing with them in Access, may the force be with you.
I recently took on several complicated chart tasks, and after 8 bruising (non-billable!) hours, managed to coax Access to properly display the data. But, next time, I’ll be using the Excel object to manage task intensive charts.
In any case, one small annoyance is the y-axis title. On some operating systems (To remain mysterious as always….Windows XP) the y-axis title gets cut-off, despite any font type or size manipulation. There is no known solution. But I did trick it to show my whole label text.
At the end of the label, add a space or two, and then a period. When the chart is rendered, the space and the period are cut-off due to the anomaly, but the full caption is visible. You may have to experiment a bit to get the results you want.
Software development for fun and profit, that’s the life for me.
