View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
sylvan sylvan is offline
external usenet poster
 
Posts: 3
Default "Stacked scatter plot"?

Like I said, I have various "times" that all add up to a total time. E.g.
"For input of size N, task A takes 4ms, task B takes 6ms, task C takes 1 ms"
etc. Each of these task's times are in a separate column, where each row
corresponds to a different N. I'd like a stacked area chart for this to show
off the total time, and the individual sub times.

This works if I just choose "stacked area" chart, the problem is that my "N"
values are not spaced out uniformly (e.g. N could be 1, 2, 4, 10,
25,50,56,63) so the "ticks" on the X-axis shouldn't be uniformly spaced out,
bur work like a scatter plot.

"Bernard Liengme" wrote:

Tell us more details about the two sets of data
Then tell us what the chart should show.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sylvan" wrote in message
...
Hi. I want to have a stacked area plot to show off how much time out of
the
total various tasks take in some simulation software I have. The problem
is
that the input data (the x axis) occurs at irregularintervals. E.g. I may
have data for 10 elements, and then the next is for 20 elements, and then
one
data point for 21 elements or whatever.

Just producing a stacked area plot looks allright, but even though the
input:time releationship is more or less linear, I get this weirdly shape
curve because Excell just assumes that the input data value pairs should
be
evenely spaced on the X axis.

Is there any way of getting it to put the "ticks" on the X axis depending
on
the actual value rather than just uniformly distributing it?