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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Salutaurs - 30 Oct 2008 01:54 GMT

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.

Reply to this Message

Carl Witthoft - 31 Oct 2008 02:32 GMT

> How to make chart include only values from every 5th column till the end?
> Manually in "values" field it looks like:
[quoted text clipped - 11 lines]
>
> Thx in advance.

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.

Signature

Team EM to the rescue! http://www.team-em.com

Reply to this Message

Mac Forum / Applications / Excel / October 2008

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