Charts - Macro - (Axis are not coming up good)

[sammymalta]

Hi.. i have a sheet with sales data.. with the years from 2004 to 2013.
Certain clients do not have any values in certain years, but when i run the macro, the years are messed up on the chart.

See attached doc. 'CLIENT A' is incorrect; 'CLIENT B' is correct (as in showing all the years). But for some reason it is picking up a value for 2004. (which is incorrect) What am I doing wrong?

Thanks
Sam

[Andy Pope]

You need to use the correct start and finish cells.

Please Login or Register  to view this content.

[AlphaFrog]

The source data for the three charts is not correct. For some reason (that I don't know why), Excel automatically truncated the data range to omit the leading bank values even though you had coded the proper data range e.g.; you coded a data range of B2:K2 and Excel automatically adjusted that to J2:K2 to omit the leading blank values.

The code below works around that.

Please Login or Register  to view this content.