How to make chart include only values from every 5th column?

S

Salutaurs

How to make chart include only values from every 5th column till the end?
Manually in "values" field it looks like:

=(dati!$D$3;dati!$I$3;dati!$N$3;dati!$S$3;dati!$X$3;dati!$AC$3;dati!$AH$3;dati!$AM$3;dati!$AR$3;dati
!$AW$3;dati!$BB$3;dati!$BG$3;dati!$BL$3;dati!$BQ$3;dati!$BV$3;dati!$CA$3;dati!$CF$3;dati!$CK$3)

But it takes a lot of time to put manually every 5th cell in "values" field.

I have chart with 2 Y axes, 1st presents column chart, 2nd - line chart.

Is there any other solution?

Thx in advance.
 
C

Carl Witthoft

Salutaurs said:
How to make chart include only values from every 5th column till the end?
Manually in "values" field it looks like:

=(dati!$D$3;dati!$I$3;dati!$N$3;dati!$S$3;dati!$X$3;dati!$AC$3;dati!$AH$3;dati
!$AM$3;dati!$AR$3;dati
!$AW$3;dati!$BB$3;dati!$BG$3;dati!$BL$3;dati!$BQ$3;dati!$BV$3;dati!$CA$3;dati!
$CF$3;dati!$CK$3)

But it takes a lot of time to put manually every 5th cell in "values" field.

I have chart with 2 Y axes, 1st presents column chart, 2nd - line chart.

Is there any other solution?

Thx in advance.
Click to expand...

well, what's in the other 4 columns and why don't you just re-arrange
your data?

Failing that, you may find it easiest to set up another worksheet which
links its cells to every 5th column,and plot from there. The formula in
each cell will look something like

=OtherSheet!$[row()*5]$3

You would need to read up a bit on INDIRECT, MATCH, CONCATENATE, and
related functions to do this.
 
Top