excel - Sorting characters instead of numeric values in Pivot Chart -
i want generate pivot chart pivot table. problem here pivot table not contain numeric values. there characters differentiate them. pivot chart sort based on characters "a" , "b".i try put characters in values column seem convert numeric values. know how sort characters instead of numeric values in pivot chart? don't have ideas. !
in general, excel charts require numbers chart anything. charts have category axis, can display text, , value axis, against numeric values plotted. in xy scatter chart, both axes numeric or value axes.
without numbers, excel won't able plot chart.
it not clear want chart like. edit question more details data , hand-drawn sketch of chart you'd expect create that. can edit answer accordingly.
Comments
Post a Comment