make data source shorter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! How can I make the below data source shorter?

=TriggerEvents!$E$7,TriggerEvents!$H$7,TriggerEvents!$K$7,TriggerEvents!$N$7,TriggerEvents!$Q$7,TriggerEvents!$T$7,TriggerEvents!$W$7,TriggerEvents!$Z$7,TriggerEvents!$AC$7,TriggerEvents!$AF$7,TriggerEvents!$AI$7,TriggerEvents!$AL$7, TriggerEvents!$AO$

Tks!
 
Hi Louisa
one way: Define an name for this series (goto 'Insert - Name - Define')
and use this name as datasource for your chart
another way: Create a helper column which duplicates these data. e.g.
starting in column G, row 1 you can use the following formula:
=OFFSET($E$1,0,(column()-1)*3 + 4
copy this to the left and you're duplicating your data

HTH
Frank
 
Back
Top