Search results for query: *

I would but the client requires that the chart be developed in this manner.

Any idea how to implement this using chartWizard?

In my case the label is not part of a single cell but as part of combining 3 individual cells.

Hi, I have a label that I would like to have wrap. See below Current Label: text 1 - text 2 - text 3 I would like Text 1 Text 2 Text 3 How would I do this with vba?

Oh yeah, I simply made my file open the other file and copy the cell data into a worksheet in my project. Then i just called the data. ------------- Dim wb As Workbook Set wb = Workbooks.Open"filename.xls", True, True) ' open the source workbook, read only With...

I found a different solution. Thanks for the help.

Charts.Add ActiveChart.ChartType = xlRadarMarkers ActiveChart.SetSourceData Source:=Workbooks("spiderdata.xml").Sheets("Data"). _ Range("A1:K20"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1" ActiveChart.HasTitle = False...

The recorded macro doesn't help.

This is not working :( Any more ideas?

I need to target an external .xls to create a chart in my project. I have: - - - - - - - - - - - With ActiveChart .ChartType = xlPieExploded .ChartWizard _ Source:=Sheets(Data).Range(myrange), _ Gallery:=xlLine, Format:=4, PlotBy:=xlRows, _...