| 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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Series Number when Create Chart
I would think you could right click on the chart and then click view code.
It should then display the properties window which would show the name of the chart. "Shiji Shen" wrote: 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! |
| Reply |
| 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 | |||
Linear Mode
