If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
... I want to change a chart type ...
I have a "Line - Column" chart in my spreadsheet.
My Bars represent the month which is in a Linked Cell. The Value of the Bars is a Dollar amount from a Linked Cell. The Line represents a Target Dollar Value. I would like to add a second line that would represent a count from a linked range of cells. Can I edit my existing chart, or do I have to create a new one? Could you give me a few pointers? Darrell |
#2
|
|||
|
|||
Select and drag the new column onto the chart. In the resulting dialog
box, ensure you specify 'new series'. Once XL finishes adding the series, if it is not the kind you want, select it in the chart and then select Chart | Chart Type... Set the chart type as desired. Keep in mind that when selecting a chart type with a single series selected affects only that one series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a "Line - Column" chart in my spreadsheet. My Bars represent the month which is in a Linked Cell. The Value of the Bars is a Dollar amount from a Linked Cell. The Line represents a Target Dollar Value. I would like to add a second line that would represent a count from a linked range of cells. Can I edit my existing chart, or do I have to create a new one? Could you give me a few pointers? Darrell |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to add animation to a chart - make lines appear | David Leonard | Powerpoint | 11 | June 2nd, 2005 12:33 AM |
Fan charts | Dean | Charts and Charting | 7 | May 30th, 2005 11:51 AM |
Change Memo data type to Text data type | DS | New Users | 1 | January 26th, 2005 04:56 PM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |