Dynamic chart
 

Hi All,

I have a problem with charting some data that I hope you can help me
with.

What I have is data in two rows:

Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the
lowest date in column 3 and quaterly on through the columns.

Row 30 is the values to the corresponding dates in row 29

My problem is that the values derived in row 29 and 30 are derrived by
formula.

Hence when I make a chart of it i get alot of zero values in my
chart..

Also the start of the data series I would like to chart might have
zeroes until column 10 or 15 or something like that.

Also, when the data starts for instances in column 7 it might have
empty (not emptry but with an blank result of the formula) cells that
I do not want to chart.

If this is not enough info please tell me what would be useful.

Best regards,
Bondi

Dynamic chart
 

Bondi

There's a page on how to create dynamic charts he
http://www.tushar-mehta.com/excel/ne...ynamic_charts/

That should get you started - ask again if you need to know more.

Andrew


On 5 Feb, 18:00, "Bondi" wrote:
Hi All,

I have a problem with charting some data that I hope you can help me
with.

What I have is data in two rows:

Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the
lowest date in column 3 and quaterly on through the columns.

Row 30 is the values to the corresponding dates in row 29

My problem is that the values derived in row 29 and 30 are derrived by
formula.

Hence when I make a chart of it i get alot of zero values in my
chart..

Also the start of the data series I would like to chart might have
zeroes until column 10 or 15 or something like that.

Also, when the data starts for instances in column 7 it might have
empty (not emptry but with an blank result of the formula) cells that
I do not want to chart.

If this is not enough info please tell me what would be useful.

Best regards,
Bondi

Dynamic chart
 

On 6 Feb., 00:24, "Andrew Taylor" wrote:
Bondi

There's a page on how to create dynamic charts hehttp://www.tushar-mehta.com/excel/ne...ynamic_charts/

That should get you started - ask again if you need to know more.

Andrew

On 5 Feb, 18:00, "Bondi" wrote:



Hi All,

I have a problem with charting some data that I hope you can help me
with.

What I have is data in two rows:

Row 29 is the dates on a quaterly basis (Q2-05 and the sorts) with the
lowest date in column 3 and quaterly on through the columns.

Row 30 is the values to the corresponding dates in row 29

My problem is that the values derived in row 29 and 30 are derrived by
formula.

Hence when I make a chart of it i get alot of zero values in my
chart..

Also the start of the data series I would like to chart might have
zeroes until column 10 or 15 or something like that.

Also, when the data starts for instances in column 7 it might have
empty (not emptry but with an blank result of the formula) cells that
I do not want to chart.

If this is not enough info please tell me what would be useful.

Best regards,
Bondi- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Thanks all

Sorted it out now

Regards,
Bondi