Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Questions about Excel Charts
1) I have a list of 50 points (X, Y) that I want to plot. In a third column,
I have the state corresponding to each point. How do I display these states on the chart (without manually entering each)? 2) I want to create a Chart where the user can input a real number (without switching to another sheet) that changes the chart (e.g., entering ALPHA for a chart plotting "SIN(ALPHA*X)"). Listboxes, spinners only work for discrete numbers, and I do not want to put the chart on an existing worksheet. How do I create a link from a sheet to an editable value on a Chart? Thank you, Ken |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Questions about Excel Charts
1. There are two good, free add-ins that perform this task nicely:
Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com 2. You could put a button on the chart, the button runs a macro, and the macro uses an input box to get information from the user. Or you could use a scrollbar, and set the max to something huge, like 100,000; divide this by 1000 to allow nearly continuous variation between 0 and 100. You can link a textbox on the chart to the cell that contains the calculated value. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "KenF" wrote in message ... 1) I have a list of 50 points (X, Y) that I want to plot. In a third column, I have the state corresponding to each point. How do I display these states on the chart (without manually entering each)? 2) I want to create a Chart where the user can input a real number (without switching to another sheet) that changes the chart (e.g., entering ALPHA for a chart plotting "SIN(ALPHA*X)"). Listboxes, spinners only work for discrete numbers, and I do not want to put the chart on an existing worksheet. How do I create a link from a sheet to an editable value on a Chart? Thank you, Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Excel Charts to PowerPoint | Charts and Charting in Excel | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
insert excel charts as objects | Charts and Charting in Excel | |||
insert excel charts as objects | Excel Discussion (Misc queries) | |||
Pasting excel sheets with charts | Charts and Charting in Excel |