Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems creating "line and bar chart"
when recording the macro, I didn't have problems creating the two series, one a bar, and the second a line. However, upon running the macro, both series appear as bars! I retried recording the macro and the same problem occurred
Please email me at ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems creating "line and bar chart"
When you look at the code that was recorded, it should look similar to this:
ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, _ TypeName:="Line - Column" ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:G3") ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1" Rearrage these lines, so the chart type is applied after the source data and location are set: ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:G3") ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1" ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, _ TypeName:="Line - Column" Ariel wrote: when recording the macro, I didn't have problems creating the two series, one a bar, and the second a line. However, upon running the macro, both series appear as bars! I retried recording the macro and the same problem occurred! Please email me at ! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabled "Switch Row/Column" when creating chart from a pivot tabl | Charts and Charting in Excel | |||
How to insert a "Target" line into basic bar chart | Charts and Charting in Excel | |||
Creating "cliffs" in an area chart | Charts and Charting in Excel | |||
Creating an"Average" Line in a Scatter Graph | Charts and Charting in Excel | |||
Lines in line chart are "agglomerating" data | Charts and Charting in Excel |