![]() Hello, I would like to create a graph from a macro. Here is what I have got so far. Charts.Add ActiveChart.ChartType = xlXYScatterLinesNoMarkers ActiveChart.SetSourceData Source:=Sheets(sheetname).Range('AF1:' & lastcell2, 'BN1:' & lastcell), PlotBy:=xlColumns ****. I'm sorry here is the code of a working graphing subroutine, not the one I am trying to get to work. I agree that knowing the various variable types will help, but without knowing that and assuming that they are 'STRING', that part of the code worked for me. What failed was when assigning the XValues. ActiveChart.SeriesCollection(1).XValues = Sheets(sheetname).Range(('AL2'), lastcell3) The error was 'Run-time error '1004': Unable to set the XValues property of the Series Class. ![]() Click the 'File' tab at the top-left corner of the window, click 'Open,' then double-click the file containing the graph that you wish to edit. Click the worksheet tab at the bottom of the window on which the graph is displayed. Click anywhere on the graph to open the 'Chart Tools' utility. How does one include subscripts in an axis label? You will see that the argument x in the function appears in a different font style than the argument on the horizontal axis. To make sure that you get a consistent font style on both axes using the default styling for graphics, you should use the following. How did you create this script? Did you record it when creating the chart originally? Best file search program for mac. Do you have any sample data you can give? Burn mp4 for dvd player mac. Download stupid zombies for mac free.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |