Does anybody know how I can view a chart of data, removing some anomalies that I dont want to display at the same time?? e.g. for a barchart I want to see the temperature on everyday of the month except for tues 22nd may because it was exceptionally high etc.
There are some ways but I would say that the faster for the user is to create a listbox with the Date, select 22nd, right click on the listbox, then click on "Select Excluded".
There are some ways but I would say that the faster for the user is to create a listbox with the Date, select 22nd, right click on the listbox, then click on "Select Excluded".
Once I have excluded the anomalies from my e.g. bar chart, Do you know is there any way to dynamically set the y-axis so that all the other data fills the screen
Sorry I don't get the second part: fill the screen. I mean, if you exclude those values from the listbox, the chart will show only those values that are excluded, won't they?
Or is that you want to show those values somewhere else in the sheet?
.png "Miguel_Angel_Baeyens"){kind=avatar}
