Linking Charts

How do I link charts to specific cells. I have 20 charts that I have created
and cannot figure out how to connect the cell to the chart when printing.

In article <[email protected]>,
[email protected] says...
> How do I link charts to specific cells. I have 20 charts that I have created
> and cannot figure out how to connect the cell to the chart when printing.
>
What does that mean? A chart plots data in a range of cells. So, in
that sense a chart is already linked to one or more cells.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

What I mean is that I have 10 lines of data. I need to print the data one row
on each page which I have setup correctly thus far. In addition to that one
row of data, I need to "pull" (be that another sheet, whatever) the chart
that corresponds to that row. So one row of data and one chart on each page.


"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] says...
> > How do I link charts to specific cells. I have 20 charts that I have created
> > and cannot figure out how to connect the cell to the chart when printing.
> >
> What does that mean? A chart plots data in a range of cells. So, in
> that sense a chart is already linked to one or more cells.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>

Put the row of data together with the chart onto a worksheet, and print
the sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Darren wrote:

> What I mean is that I have 10 lines of data. I need to print the data one row
> on each page which I have setup correctly thus far. In addition to that one
> row of data, I need to "pull" (be that another sheet, whatever) the chart
> that corresponds to that row. So one row of data and one chart on each page.
>
>
> "Tushar Mehta" wrote:
>
>
>>In article <[email protected]>,
>>[email protected] says...
>>
>>>How do I link charts to specific cells. I have 20 charts that I have created
>>>and cannot figure out how to connect the cell to the chart when printing.
>>>
>>
>>What does that mean? A chart plots data in a range of cells. So, in
>>that sense a chart is already linked to one or more cells.
>>
>>--
>>Regards,
>>
>>Tushar Mehta
>>www.tushar-mehta.com
>>Excel, PowerPoint, and VBA add-ins, tutorials
>>Custom MS Office productivity solutions
>>