Find solution
How to update the Tkinter graph?

Frustration high due to Excel problem - how do I make my sorted data update in my graph?

  • Frustration high due to Excel problem - how do I make my sorted data update in the graph? Ok, so I have this excel sheet that pulls data from an outside source (its actually a Bloomberg Excel-Add In). I use this data to make a bar graph. I sort the data so that the bar graph looks all nice and in order. Only its not always in order. Sometimes the first set that I sort will update the graph and the second and third set that I sort will not. What do I have to do to make the graphs be SORTED? Help me....please. I feel this should be simple. Thank you in advance for ridding my life of this problem.

  • Answer:

    try mrexcel.com forums

Carialle at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

Are they always sorted on the same field(s)? You could create a custom list and then run a macro or VBA sub to perform the sort upon an action (worksheet open, button click, etc).

mezzanayne

I can't understand your question well enough to diagnose your problem, but any time I work with BBXL or something similar, I copy/paste special, values to another sheet in the workbook. Most of the funny business disappears when one works with the real data rather than the API links.

Kwantsar

Turn on macro recorder. Do your sort the way you usually do. Turn off macro recorder. Get new data. Run macro, see if it sorts right. If it doesn't, run it line-by-line until the mistake happens. Fix. Run macro again. Continue until it works right.

BitterOldPunk

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.