Chart Questions

J

James L

Hello

Is it possible using formula or vba to create a chart from a table that only shows headings that have values greater than zero. I tried Charts("Chart1").DisplayBlanksAs = xlNotPlotted but couldn't get it to work

Thanks in advance

James
 

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

Drop down list control value in vba 2
HIDE VALUE 0 FROM CHART 1
Gantt chart duration not showing 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Earned value (BCWP) showing as zero in chart 0
Excel chart, set a vertical baseline on a certain date 1
How to write macro to set the chart scale min/max property? 5
Create several charts in one go using VBA 4

Top