Here's some code from Excel 2010 that may work. You can select the series just as you could in Excel 2003, but you must use the "Add" and "Edit" buttons to define custom series. This opens up a dialog box listing the Series for the chart. For 2007, when the chart is selected, you should be able to do a similar action using the "Select Data" option on the "Design" tab of the ribbon. The button on the right of the field can be clicked to unhide the wizard.ĮDIT: The above applies to 2003 and before. Select the appropriate sheet in the workbook and then select the fields with the data you want to show in the chart. When you click it, the Wizard temporarily hides itself (except for the field you are working in) allowing you to interact with the workbook. This icon allows you to select cells in the workbook to pull the data from. There is an icon in each field on the right side. Notice that the values for "Name" and for "Values" change when you highlight a series in the list box. This will add a blank series to your list box. The final field is the "Category (X) axis labels" field, which is common to all series.Ĭlick on the "Add" button below the list box. Each series has both a "Name" field and a "Values" field that is specific to that series. The list box shows the different series you are already including on the chart. There are 3 fields and a list box on this tab. On Step 2 of 4, there is a tab labeled "Series".
0 Comments
Leave a Reply. |