Hello. I have an excel sheet with a list of aluminum samples and their concentrations of each element, and I need an easy way to view them. I've made scatter plots that have each sample's concentration for a specific element, but I would like to have some sort of control to easily change the data range of the chart.
For example, we have samples anywhere from 0% Silicon to 7% Silicon, but there are exponentially more points in the 0% to 0.4% range. I want to have all of the points on the chart then be able to easily switch from viewing a 0-0.4 range to a 1-2.5 range without having to format the axis.
Is this possible? Thanks in advance for the help!
Bookmarks