chart 2003

I have several worksheets - one stock per worksheet containing all the necessary data to construct a VOHLC chart embedded in each worksheet. This all works fine, however, I cannot work out how to change the volume bars from the current dark blue to orange. I know how to do it manually but not...

Sorry I’m new to vba and need help about creating VBA code for xlStockOHLC chart to new worksheet. I have a ticker worksheet (Symbol) with a list symbol on column A (eg, A7,A8, A9 and so on), the existing code will select from A7 symbol (eg, Appl) and download historical data (column...

Hello, I'm having some trouble making a dynamically updating chart in excel 2003. I'm fairly new to excel, but my boss wants me to make a graph that will update every week as we recieve more info into a certain file. Basically it's the alcohol drinking habits of the southern states, broken...

Hi, I have faced a major problem with refreshing charts on my excel file: I have been building an Excel 2003 based model, which has several worksheets in it with hundreds of columns and rows of interconnected data, formulas and 2-4 charts on each worksheet. Until recently the charts refreshed...

I have this chart maker that makes bar charts structured with multiple series (upwards of 100) and then colors in the bars based on other criterion. I'm not going to post the entirety of my code because it's just a snippet that seems not to work. By not work, it's not that there are bugs, it's...

hello I recently changed the default chart settings in excel because i had to make a lot of graphs with identical layouts, assuming that it would be easy to reset the default chart option but I can't figure out how to do it. Does anyone know how? very much appreciate

I have a while loop that counts backwards in a seriescollection to find the last value with data. In one particular case, I had to use an IF formula in the source data where it would output NA() if the statment was false, so instead of loop through empty strings until the loop finds a number, it...

Hi, I have seen various discussions about creating a speedometer style dial using 2007 etc but no conclusive way of doing it in 2003. (Maybe there isn’t). Anyway I set out to have a go myself. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Ok, I started...