Please Help!! Excel driving me mad!
I didn't know which section to put this in. I have a general excel query, rather than a VBA one.
I'm running Excel 2000. I'm creating a series of charts, which are all 3D 100% stacked column jobbies. I have quite a few to create, all looking at identical blocks of data, all the same size and shape. To save me re-formatting the graph each time I create one, I'm simply copying an existing chart sheet and re-defining the source data range. When I get to graph number 4, the look of the graph suddenly changes. The stacked columns appear as thin as spagetti and there's absolutely no explanation or anything I can do about it
! I've even tried copying the chart sheet and re-defining the source data to look at the same range it was looking at anyway, yet the chart still changes in appearance. When I go to format the x-axis, I'm presented with a completely different set of options to the other charts as well.
Unfortunately, i can't back my query up with any illustrations. Has anyone experienced this! I hate it when Excel just decides not to play with no logical explanation!!!
Thanks for any help, and I apologise if this is not the forum for these issues, but I can't think of anywhere else.
Keith
