The latest free trial version can be downloaded here:įor detailed testing of this new product download a runnable solution here. You can refer to the following article for more information about Charts: Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3" Accessing the instance of the newly added chartĪ chart = worksheet.Charts Int chartIndex = (.ScatterConnectedByLinesWithDataMarker, 5, 0, 15, 5) Worksheet worksheet = workbook.Worksheets Set the minimum value to be zero, the maximum value to match the highest value of your data. On both the Minimum and Maximum Bounds value changes from auto to fixed. Obtaining the reference of the newly added worksheet by passing its sheet index Right-click on the numbers along the bottom of the chart that represent the horizontal axis. Adding a new worksheet to the Excel object (Notice how the point moves over when you do so.) 4. Show the Secondary Horizontal axis by going to the Axes menu under the Chart Layout button in the ribbon. Select the point, right-click to Format Data Series and plot the series on the Secondary Axis. Following example demonstrates this feature briefly. Select that column and change it to a scatterplot. You can create scatter charts and set all the relevant properties. A new product Aspose.Cells has replaced it that contains all the features of its predecessor along with the support for the latest features in different versions of MS Excel. If it is of interest, I can give more details. I havent offered this as an answer because I dont know a way of extending it to more than 3 x-values. Is discarded and no more under active development. If you only have two or three countries to display, you can use x-values of (say) -1,0 and +1 and a custom format of (say) 'Germany' 'Poland' 'Other' for the x-axis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |