| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Number when Create Chart
I recorded a macro to create a line chart for my future chart creation. The
macro automatically gives a series number of the chart e.g. ActiveSheet.Shapes(€śChart 8€ť).xxx based on how many charts created on the same sheet in the past, even though the previous charts are all deleted. - How can I know the series number for the chart I am to create? - Can I get around this series number and have a customized name for the chart, so that I can work with it? This series number problem is true for adding a sheet. I need to know the series number before I can change the name of the sheet. e.g. Sheets.Add Sheets("Sheet1").Select Sheets("Sheet1").Name = "NewName" If a previous Sheet1 was deleted, then it would be €śSheet2€ť. How can I know which number it is? Any help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a function that counts number of cells in a series | Excel Worksheet Functions | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| How do I create Multiple Series in a Bubble Chart? | Charts and Charting in Excel | |||
| Create XY (Scatter) Chart, with 3 column (X, Y, Series) | Charts and Charting in Excel | |||
| create chart from series grouped by value in another column | Charts and Charting in Excel | |||
Threaded Mode
