Formula property of a series in a chart

A

Ali

Hello
I can acquire the formula of a series in a chart if the values sourced are valid figures, but when im sourcing to values which are all #NA(), so not visible on the chart, i can seem to acquire the formula of that series?? anyway round this? apart from changing the #NA() to zero's.

many thanks ahead?
 
J

Jon Peltier

Ali -

Try first to change the Series.ChartType to xlArea. Then you can access
the .Formula and the .Values, .XValues, and other properties.

- Jon
 
A

Ali

Thanks for that. I would never have thought of that! Cheers!

ps your website is great. and was really informative for excel VBA.nice one!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gantt chart duration not showing 0
Drop down list control value in vba 2
Why do charts disappear? 3
Using =Offset in Charts 1
VBA access to a series, after it was assigned to an empty range 0
SeriesCollection(2).Formula returns formula for series 1 1
Is it possible to multiply a chart series formula? 4
add a chart in a Add-In 1

Top