How can I turn off the automatic ordering of the data in Pivot Cha

J

Jammer

I have some data, which I would like to rearrange in the chart, but it's
automatically re-ordering it. I have tried manually re-ordering the data,
but that's not helping. The Pivot chart seems to automatically override what
order I put the data in, and charting it as it wants. I have tried
unchecking the Automatic Formatting, but no change. Help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 graphs/charts automatically populate with new data 1
Pivot chart: wrong date order on horizontal axis 1
Chart color 1
Chart size changes with change in data 1
I Need a Blank Chart! 1
run macro automatically when user changes the data poit in Pivot c 1
Pivot Table and Pivot Table dates are not in correct order 3
How I can set dynamic pivot table ONLY when I have enough data point 1

Top