|
|
|
||||||||||||
|
#1
|
|||
|
|||
|
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. |
|
#2
|
|||
|
|||
|
Re: Linking Charts
In article <4FA8F588-A726-405F-ACC0-1E58CE841140@microsoft.com>,
Darren@discussions.microsoft.com 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 |
|
#3
|
|||
|
|||
|
Re: 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 <4FA8F588-A726-405F-ACC0-1E58CE841140@microsoft.com>, > Darren@discussions.microsoft.com 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 > |
|
#4
|
|||
|
|||
|
Re: 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 <4FA8F588-A726-405F-ACC0-1E58CE841140@microsoft.com>, >>Darren@discussions.microsoft.com 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 >> |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|