How to Squeeze out blank columns (conditional formated chart)

  • Thread starter Thread starter bobbele
  • Start date Start date
B

bobbele

Hi,

i need help,
i am trying to format a chart - I need one column to show what "had to be"
done
- and one "done" to compare with
that "had to be"
if done is more or equal than the "hat to be" column, the column apears in
green
if done is less than "hat to be" the column apears in red
i've done it like at the following site.
http://peltiertech.com/Excel/Charts/format.html#CondChart

Now my problem ist to ssqueeze out the blank column.

thanks


Boris Stumpf
 
Right-click on one of the columns
Choose Format Data Series
Select the Options tab
Set the gap width to zero.
Click OK
 
Back
Top