Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts - Adding additional data problem.
Hi,
I would be really grateful if someone could help. I have a chart created in a seperate sheet to the source data. The problem I am having is adding additional data to the chart. The source data is not within a range of cells, but situated in individual cells in various sheets within the workbook. The method I am using is this: 1. Right click within the Chart Area and select Source Data from the submenu. 2. With the Series tab selected by default, select the relevant Series title from the Series dropdown list. 3. Next, in the Values box click the collapse dialog box button, and browse to the cell in the sheet where the data is being held and highlight to select. 4. Once steps 1 -3 have been completed for the relevant series titles browse and highlight the relevant Category (X) axis labels. The Name value in each case I have left and not altered. What should be in here? Anway, every time I attempt to add more data to the chart it creates a new chart with the data in the 'data table' being positioned in the centre. Why is this? I would be so happy if someone could tell me where I am going wrong. Many thanks in advance. Simon. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data labels to charts | Excel Discussion (Misc queries) | |||
Adding additional data to a pivot chart | Charts and Charting in Excel | |||
Automatically Adding Data to Charts | Charts and Charting in Excel | |||
Additional colors for Excel charts | Charts and Charting in Excel | |||
An additional charts package? | Excel Discussion (Misc queries) |