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

August 29, 2007 1:13 PM

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.

posted by Carialle to computers & internet (4 comments total)

try mrexcel.com forums
posted by BigBrownBear at 1:19 PM on August 29, 2007

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).
posted by mezzanayne at 1:28 PM on August 29, 2007

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.
posted by Kwantsar at 2:11 PM on August 29, 2007

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.
posted by BitterOldPunk at 2:59 PM on August 29, 2007