View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
KenF KenF is offline
external usenet poster
 
Posts: 4
Default 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