Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
I know there must be a simple way to do this.. I'm just not all that good at
excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
Hi,
Jon Peltier has information on hyperlinks and charts. http://peltiertech.com/Excel/Hyperlinks.html Cheers Andy Roney wrote: I know there must be a simple way to do this.. I'm just not all that good at excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
Exactly what I needed! Thanks Andy
"Andy Pope" wrote: Hi, Jon Peltier has information on hyperlinks and charts. http://peltiertech.com/Excel/Hyperlinks.html Cheers Andy Roney wrote: I know there must be a simple way to do this.. I'm just not all that good at excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a
copy of 1, but with different data. Now, when I click the hyperlink in spreadsheet 2, it takes me to a completly different place in the workbook. I have tried deleting and recreating the link. The link dialog has the correct references. It just doesn't work. It's weird. Spreadsheet 1 still works fine. Any thoughts? "Andy Pope" wrote: Hi, Jon Peltier has information on hyperlinks and charts. http://peltiertech.com/Excel/Hyperlinks.html Cheers Andy Roney wrote: I know there must be a simple way to do this.. I'm just not all that good at excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
What method of hyperlinking did you use?
Where should the hyperlink be taking you and where does it actually take you? If you where to create a new workbook with the same links does the problem persist? Roney wrote: Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a copy of 1, but with different data. Now, when I click the hyperlink in spreadsheet 2, it takes me to a completly different place in the workbook. I have tried deleting and recreating the link. The link dialog has the correct references. It just doesn't work. It's weird. Spreadsheet 1 still works fine. Any thoughts? "Andy Pope" wrote: Hi, Jon Peltier has information on hyperlinks and charts. http://peltiertech.com/Excel/Hyperlinks.html Cheers Andy Roney wrote: I know there must be a simple way to do this.. I'm just not all that good at excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
simple chart question
Without being able to offer any explaination, I was able to fix this. At one
point I had this spreadsheet open with two windows (window menu, new window). I closed window 1 and saved it with window 2 open. I know of no way to "undo" that. I noticed that, in the broken spreadsheet, whenever I opened it the name was "spreadsheet_name.xls;2" signifying it though it was opening window 2, though there was in fact only one window. I opened a new workbook, copied the sheets from the old to the new, saved the new using the old name, and that fixed the links. Why, I have no idea. Thanks for you help Andy. "Andy Pope" wrote: What method of hyperlinking did you use? Where should the hyperlink be taking you and where does it actually take you? If you where to create a new workbook with the same links does the problem persist? Roney wrote: Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a copy of 1, but with different data. Now, when I click the hyperlink in spreadsheet 2, it takes me to a completly different place in the workbook. I have tried deleting and recreating the link. The link dialog has the correct references. It just doesn't work. It's weird. Spreadsheet 1 still works fine. Any thoughts? "Andy Pope" wrote: Hi, Jon Peltier has information on hyperlinks and charts. http://peltiertech.com/Excel/Hyperlinks.html Cheers Andy Roney wrote: I know there must be a simple way to do this.. I'm just not all that good at excel. I have a pre-created chart. I want to put that chart on a sheet and, when the user clicks a "show chart" link, in another sheet in the same workbook, simply have that chart display. How can I do that? Thanks a lot -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Simple chart | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |