My chart has gaps and I want to remove them. The gaps are from the zeros in my data table. I cannot eliminate those. I tried to type =NA() to show as an error so that the chart won't read it, but it still does.
My chart has gaps and I want to remove them. The gaps are from the zeros in my data table. I cannot eliminate those. I tried to type =NA() to show as an error so that the chart won't read it, but it still does.
Please post ur spsht so we can take a closer look....seems there might be more then meets the eye...
The NA() trick in charts will only suppress data markers.
It will not break lines or remove categories.
Either hide the rows, making sure Plot visible cells only is enabled.
Or construct a table of data specifically for charting that does not contain gaps.
Ahh - I see... Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks