Thanks, that worked
I have another related question. Is there anyway to assign a color to the series.
I have tried the chart.series.item(0).color, but this doesn't do exactaly what I need.
It appears that ChartFx assigns the first color to which ever series/column data it finds first. We have two companies at our site. So I am producing two charts. I would like to make sure that "truck" is always blue and "rail" is always red. With the charts on the same page it is deceiving when one has mostly red bars and the other mostly blue, yet both mean truck shipments!
Is there any way to tie the color to the data in the series and not just the series.item?
Thanks again
Joyce