![]() |
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. |
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 |
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 |
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