代表指定圖表中的數列。Series物件是SeriesCollection集合的成員。 註解 使用SeriesCollection(索引) ,其中index是數列的索引編號或名稱,可傳回單一Series物件。 數列的編號指出數列新增到圖表中的順序。SeriesCollection(1)是第一個新增到圖表中的數列,而SeriesCollection(SeriesCollection.Count)則是最後一個新增的數列。
運算式。HasSeriesLines 需要expression。 可傳回 [套用至]清單內其中一個物件的運算式。 範例 本範例開啟第一個圖表群組的數列線,並設定其線條樣式、粗細和色彩。 此範例應該在具有兩個以上數列的 2D 堆疊直條圖上執行。 VB WithmyChart.ChartGroups(1) .HasSeriesLines =TrueWith.SeriesLines.Border .LineStyle...
運算式。SeriesLines 表達會傳回SeriesLines 物件的運算式。 範例 本範例會開啟圖表上第一個圖表群組的數列線條,然後設定其線條樣式、粗細和色彩。 此範例應該在具有兩個以上數列的 2D 堆疊直條圖上執行。 VB WithmyChart.ChartGroups(1) .HasSeriesLines =TrueWith.SeriesLines.Border .LineStyle = xlThin .Weigh...
運算式。ShowSeriesName 需要expression。 可傳回 [套用至]清單內其中一個物件的運算式。 註解 在您以程式方式存取資料標籤之前,必須先啟動圖表。 範例 本範例會顯示第一個圖表第一個數列之資料標籤的數列名稱。 VB SubUseSeriesName() ActiveSheet.ChartObjects(1).Activate ActiveChart.SeriesCollection(1) _ .DataLa...
Legends can distract users. Instead, use data labels as legends directly on the graph. Modify text color to match line color for better readability. Steps: SelectData Labelsand click onMore Optionsfrom theChart Elementmenu. In theFormat Data Labelswindow, change the option fromValuetoSeries Name...
Enter theSeries valuesif required. Click theOKbutton. Open up the Excel spreadsheet where you can find the desired chart. Then, select the chart in the spreadsheet and right-click on it. In the context menu, you will see an option calledSelect Data. You need to click on it. ...
Step 4: Type in the Values for the Axis Titles Once you have turn on the Axis Titles option, you type in a value for each axis title. Double-Click on the horizontal or vertical axis title and then you can type in an appropriate name for that chart axis. ...
Insert a bar graph (see Example1). Right-clickthe bar graph and chooseSelect Data… In theSelect Data Sourcewindow, clickAdd. Go toEdit Series. InSeries name:,enterMaximum. InSeries values:, refer toD5:D16. ClickOk. In theSelect Data Sourcewindow, clickOK. ...
Select the series, then click Edit. Has the 'Series X Values' been set to the correct range? If not, specify the correct range. If not, close the dialog, then select the range with X-values. Make sure that the number format is set to General or to Number. If this is in a co...
Select the series, then click Edit. Has the 'Series X Values' been set to the correct range? If not, specify the correct range. If not, close the dialog, then select the range with X-values. Make sure that the number format is set to General or to Number. ...