Chart

[Guest]

I need to remove a column displaying but leave the legion at the bottom of
the screen for that column. The chart has 5 columns with 5 legions however I
only want to display 4 columns and leave the 5 legions displaying

 

[Echo S]

If you can still leave a space for the chart column, you could just put in a
0 as the data.

Or you might experiment with plotting the one data point on a secondary
axis. You may need to change the chart type to stacked column if you do
this. (Haven't tried it here, just thinking aloud, really.)

Or you could just add the 5th legend entry by hand -- add a textbox and a
filled autoshape. In other words, fake it.