woensdag 16 oktober 2013

Excel: Invert If Negative With Corresponding Background

Just an idea.


A simple idea. Here are the data from A1:C10:

0-10% 125 500
10-20% -24 -500
20-30% 245 500
30-40% 432 500
40-50% -123 -500
50-60% 235 500
60-70% 53 500
70-80% 67 500
80-90% -87 -500
90-100% 98 500

C1:C10 contains a formula:

=IF(B1>0;500;-500)

  • All three series are in the column graph.
  • Series 3 is connected to the secondary axis.
  • Series 3 Overlapped 100% and No Gap 0% and Transparancy 50%.
  • Both Y-axis between -500 and 500.
  • Both series: Invert if negative.
  • Right Y-axis removed.
  • Data labels for the second series switched on.
You can also download the file excelbackground.zip through this link:

https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing
Een reactie plaatsen