Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Data Label value with VBA to a chart
Hi all, i recorded a macro to make a basic bar chart and selected it to show
the data label value, but it does not show it when i run the macro. Any assistance will be appreciated. -- Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Data Label value with VBA to a chart
when a chart first gets created it is on its own sheet. If you put it on a
worksheet the chart changes names but is still active. See code below. Set NewChart = Charts.Add NewChart.ChartType = xlXYScatter NewChart.SetSourceData _ Source:=Sheets("Sheet1").Range("H12:I13"), _ PlotBy:=xlRows NewChart.Location _ Whe=xlLocationAsObject, Name:="Sheet1" Set NewChart = ActiveChart NewChart.SeriesCollection(1).ApplyDataLabels _ AutoText:=True, _ LegendKey:=False, _ ShowSeriesName:=False, _ ShowCategoryName:=True, _ ShowValue:=True, _ ShowPercentage:=False, _ ShowBubbleSize:=False "Les" wrote: Hi all, i recorded a macro to make a basic bar chart and selected it to show the data label value, but it does not show it when i run the macro. Any assistance will be appreciated. -- Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a single label on excel chart | Charts and Charting in Excel | |||
Edit Pie Chart Data Label | Charts and Charting in Excel | |||
Adding a certain text label in a excel chart | Charts and Charting in Excel | |||
Implementing a Label with certain data in Chart | Charts and Charting in Excel | |||
Possible to add second data label to pie chart? | Charts and Charting in Excel |