Skip to Content
Former Member
Aug 12, 2011 at 05:36 PM

Need a chart selective of displayed ranges of info on one chart area


I have a fairly simple chart that has already been created. One side (X) is grouped by department, the other side (Y) is the usage count for each department. Most of the data contains usage under a count of 2,000. Some data contains usage within the 6,000 - 10,000 range. Then, there are 2 outliers: one at 19,000 and another at 55,000. I would like to have one chart which displays these different ranges of data while leaving out the unnecessary ranges, such as the area between 20,000 - 50,000, for example. Ideally, I would like to have multiple breaks in the chart with some type of distinct separtation so that it is obvious to the user that the chart is not cintinuously, and therefore, normally scaled. Does anyone know how I would go about this task?