![]() Top = Top 'resize '.Border.Color = vbBlue End With Dim ax As Axis Set ax = ActiveChart.Axes(xlValue) With ax. Border.Color = vbBlack End With = "Returns Distribution" Sheets("Chart").Select Range("A74").Select ActiveSheet.Paste With ActiveChart.Parent. Thanks!! Sub Histogram() AddIns("Analysis ToolPak").Installed = True Sheets("Calc").Activate Range("I1").Select Application.Run "ATPVBAEN.XLAM!Histogram", Sheets("CData").Range("$B:$B"), _ ActiveSheet.Range("$L$1"), ActiveSheet.Range("$C$2:$C$12"), False, False, _ True, True ActiveSheet.ChartObjects(1).Activate With ActiveChart.Parent. You will learn how to make a histogram in Excel along with using real business data and applica. I already did application.displayalerts = false and that doesnt fix it. This video is a quick introduction into histograms in Excel. I'm looking to find either a way to fix the hidden data, (which I dont know why it would hide data) ![]() "Histogram - Some Data will be hidden by embedded chart" ![]() ![]() When I have c# launch the macro I get the following error message: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |