ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Gurus--Please Help (https://www.excelbanter.com/charts-charting-excel/45705-chart-gurus-please-help.html)

Conan Kelly

Chart Gurus--Please Help
 
Hello all,

I have this buggy chart. I posted her within the last 2 weeks, but people
couldn't offer much help w/o pics and the file. For anyone who is willing
to help, go to http://home.att.net/~ctbarbarin/files/please_help.htm for the
whole story, pics, and to download the file for you to mess with.

Any help with this will be greatly appreciated,

Conan Kelly



Andy Pope

Hi,

The skinny columns in 2003 are caused by the chart automatically setting
the scale to be base on days not months. You could set the base unit to
be Month. But it would probably be better to set the axis to being
category. To do this right click in the chart and choose Chart Options.
On the scale tab pick Category instead of automatic.

Cheers
Andy

Conan Kelly wrote:
Hello all,

I have this buggy chart. I posted her within the last 2 weeks, but people
couldn't offer much help w/o pics and the file. For anyone who is willing
to help, go to http://home.att.net/~ctbarbarin/files/please_help.htm for the
whole story, pics, and to download the file for you to mess with.

Any help with this will be greatly appreciated,

Conan Kelly



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com