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
|
|||
|
|||
How do I pass series data x-value range to a chart from a cell?
I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have
two worksheet cells (B1 & B2) that contain the start and end date for the x-axis of the chart. I want to be able to link the chart series data to the start and end date values so that the chart automatically adjusts when I change the dates in the worksheet cells. I can create a string or address for the x-values but how do I do not know how to pass this to the chart series?? I know I can do this using a macro, but I want to do it without macros so that friends who use MicrosoftCharts (the cheap, no macro version of Excel) can still use the charts. |
#2
|
|||
|
|||
How do I pass series data x-value range to a chart from a cell?
See
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html particularly, example 3. Since I don't know anything about MicrosoftCharts I cannot say if named formulas will work there. -- Regards, Tushar Mehta www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "Ian" wrote: I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have two worksheet cells (B1 & B2) that contain the start and end date for the x-axis of the chart. I want to be able to link the chart series data to the start and end date values so that the chart automatically adjusts when I change the dates in the worksheet cells. I can create a string or address for the x-values but how do I do not know how to pass this to the chart series?? I know I can do this using a macro, but I want to do it without macros so that friends who use MicrosoftCharts (the cheap, no macro version of Excel) can still use the charts. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stock High-Low-Close Chart | Tim | Charts and Charting | 7 | August 24th, 2007 01:02 PM |
How to create a chart based on a 2 dim data range dynamical in 1 d | Beertje | Charts and Charting | 1 | October 25th, 2005 11:54 AM |
Need to Add Column to Data in Pivot Table | Jay | Charts and Charting | 1 | October 15th, 2005 02:43 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Shading a range between two series in a chart | Jon Peltier | Charts and Charting | 0 | May 20th, 2004 03:49 AM |