ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Linking Charts (https://www.excelbanter.com/charts-charting-excel/52289-linking-charts.html)

Darren

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.

Tushar Mehta

Linking Charts
 
In article ,
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

Darren

Linking Charts
 
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 ,
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


Jon Peltier

Linking Charts
 
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 ,
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



All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com