Charting error - With dynamic input

[Krishnaraj]

Hello All,

I am facing trouble in plotting a graph, wherein the input rows are dynamic and i would need plot the graph with the standard named rows.

Basically the chart compares 2 standard product lines, but in the input data sheet the no.of rows differ and hence the position of the required rows keep shifting. Hence was trying to map the graph bars to the named rows in the 'chart data range' with some of the reference formulas along with 'series' function but did not end up anywhere. Also not sure if this would be a possile approach at all!

Greatful to your help! thanks in advance.

 

[Andrew Poulsom]

Welcome to MrExcel.

This shows you how to create a dynamic chart:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

If you need more help post back with specifics of your problem.