active chart option

  • Thread starter Thread starter giacomo
  • Start date Start date
G

giacomo

How do I activate the "Active chart" option in "Chart"
tab of "Options" selection under the "Tools" menu? I can
see it but I can't activate it.
Regards,
giacomo
 
Hi giacomo,

Try selecting the chart before going to Tools > Options

Cheers
Andy
 
Thanks very much Andy. It activated "active chart", but
unfortunately it doesn't solve my problem which is: I
would like the chart to ignore (ie not chart) cells with
no dates or numbers in them (just ""). Is that possible?
Thanks for your time,
giacomo
 
Hi,

If the cells with "" in are as a result of a formula then try using the
function NA() instead. This will stop lines from dropping to zero.
If you want ignore the cell you will have to hide the row or column.

Cheers
Andy
 
You must log in or register to reply here.

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

Help with VBA code 1
Activate Chart Buttons 1
How do I get all 5 graph charts to show data (not be greyed out)? 1
How do I stop chart from plotting null values as zeros in excel 20 3
How to create a bubble chart with more than 2 variables 0
Line charts with missing data points in Excel 2007 2
Excel 2007 Chart - determining the color of a chart style 1
charting that ignores non numeric/date cells 3

Back
Top