Is there any way in Excel 2010 when creating a 2-D Column chart to compress the white space between the series of columns if you don't have numbers to graph for some of the series? For example, say I have the following information:
1st 2nd 3rd
Apples 25 30 27
Oranges 28 32 28
Pears 16 22
So since I don't have a number for Pears for the 2nd period, I want the 2nd series to not have as much space, so to speak, as the other two series. Is this even possible? And if so, how? And is it possible without Visual Basic, because I don't know enough about Visual Basic?
I have attached a file as an example. The first series doesn't have anything to chart for the Plan Operating Income, so I don't want as much space for that 1st series. Any way to do this?