As you roll your mouse pointer over each option, Excel supplies a brief description of each chart sub-type. There are further sub-types within each of these categories. For example, after you choose Column Chart, you can choose to have your chart represented as a two-dimensional chart, a three-dimensional chart, a cylinder chart, a cone chart, or a pyramid chart. After you choose a chart type, such as column, line, or bar, you choose a chart sub-type. You select a chart type by choosing an option from the Insert tab's Chart group. As you change your data, your chart will automatically update. The basic procedure for creating a chart is the same no matter what type of chart you choose. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. SeriesCollection(6).In Microsoft Excel, you can represent numbers in a chart. Here is the code which reproduces the graph The commented part is my third line which gives me the error.Ĭan anyone help me resolving this problem SeriesCollection(6).MarkerBackgroundColorIndex = 33 SeriesCollection(5).MarkerForegroundColorIndex = 1 SeriesCollection(5).MarkerBackgroundColorIndex = 36 SeriesCollection(4).MarkerForegroundColorIndex = 1 SeriesCollection(4).MarkerBackgroundColorIndex = 8 My excel graph contains bar and line representation with tow secondary axis, there are some three bar representation and three line representation, I am able to set the Markerstyle property for two lines but when I am trying to define the style of the third line it is not allowing me to define the MarkerStyle property, I am getting the above error. It works perfect but I am having a small problem in formatting my graph, I am getting an error " unable to set the SeriesCollection property of the series class " My output is an excel sheet with the graph in it designed from my Foxpro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |