Ok, so here goes.
I am creating a chart from lots of data but from this I need to create several others so I am unable to delete these lines (which is what I would normally do) I have a number of cells which are blank and I can't find how to remove these from the particular chart, is there a really easy way to do this?
Any help would be appreciated.
Katie
Difficult to say without seeing your data layout.
Personally I would create 'tables' that are fed from your main dataset and reference those with the charts.
If I've been of help, please hit the star
As far as I can remember, it's in Excel properties under charting..There is a radio button for interpolation..
Elegant Simplicity............. Not Always
Sorry people I am self taught and what you have both said doesn't make much sense to me
I will try and upload an example of this to see if it helps any
Maybe this explanation will help
http://office.microsoft.com/en-gb/ex...010048555.aspx
Thanks for that, however, the option to connect data points is greyed out??
I have attached the chart for you.
That's because it's a bar chart
The chart updates when you hide cells by using the filters,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks