• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Graphing

B

BDawg

Lifer
If I have a list of 20 names and values, I can sort them by values and then physically select the top 10 of the names and values.

However, if I sort them again by a different criteria, my chart changes and shows the the first 10 (which are now sorted by a different value).

How do I select a static top 10 that doesn't change when I re-sort the list?

Ex:

I have the following chart

West Joe 10
East Dave 9
South Tom 8
East Jane 7
North Ellen 6

If I want to graph the top 3, I can just select Joe, Dave, and Tom and their values.

But, if I sort by the location, my data changes to the following

East Dave 9
East Jane 7
North Ellen 6
South Tom 8
West Joe 10

So my graph changes to include only Dave, Jane, and Ellen...no longer the top 3. How do I keep my chart to stay with the top values?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top