Search results for query: *

Does anyone know how to create an Excel chart directly from VBA without first putting the source data on a spreadsheet? I am trying to do a short animation by refreshing the chart a number of times. The problem is that the extra step of displaying the data on the spreadsheet slows down the...

I want to be able to create a chart that will automatically have the right aspect ratio. Say for example I was trying to plot an ellipse. Excel may plot that ellipse to look like an ellipse, or it could be stretched to look more like a circle, depending on the scale of the x and y 'Major...

This is driving me nuts. It happens maybe 1 out of 3 times I open the file. I have found two cases which cause excel to crash and want to send an error report to microsoft. The first one is when I open a file in which I have a splash screen set up according to the directions given on this...

I'm sure this is really simple but I can't figure it out. I want to rename the charts in my excel sheet so that when I code in VBA it is easier to know which is which. Right now they are Chart1, Chart2, etc. To give you a better idea of what I'm trying to do: I want to rename a chart the...

I need to make one textbox display in scientific notation and a couple others have only 2 decimal places. The data is being brought in from excel. Does anyone know how to do this? Thanks!