I have three sets of data in the attached spreadsheet. One X (Current Offering), one Y (Strategy), and then a third (Market Presence) that I don't know what to do with as it determines how big the plotted X,Y plot points are.
I essentially would like to replicate the attached jpg. Not sure how to combine the area chart (the radial circular lines) with the other data either. I don't have that data in the sample.xlsx though. I guess I would have to make it up to form the 4 areas to the chart.
I understand that in order to also display the labels for the data I need to do it through XY Chart Labeler
http://www.appspro.com/Utilities/ChartLabeler.htm
I've downloaded it, but haven't tried it yet, but I'm sure I can figure it out. There's several posts here on how to do it.
I'm in Excel 2007.
Is it possible to Create excel chart ( normal distribution curve) based on the output of Descriptive statistics
For example : Would it be possible to create normal distribution curve in excel using following Descriptive statistics output
Mean 118247.4547
Standard Error 210.3114405
Median 117081.5
Mode 91374
Standard Deviation 19711.01832
Sample Variance 388524243.3
Kurtosis 0.097330952
Skewness 0.450270462
Range 112097
Minimum 76095
Maximum 188192
Sum 1038685642
Count 8784
Largest(1) 188192
Smallest(1) 76095
Confidence Level(95.0%) 412.2596498
thanks ,
Hi, is it possible to chart 3 sets of data -- two as points on a scatter-plot charted kind of thing + one as a 3D-column-indication, to indicate how many responses (it's data from a survey) are included in the dots represented on the scatter-plot chart?
(So, two columns of data are creating one dot, and I'd like a third set of data to indicate the height of this dot, with the number of responses indicated, by height of this hopefully-columnar thing, along with the actual number shown).
*I already have the two sets of data indicating dots across a scatter-plot chart, though also need these dots to incorporate the third set of data to indicate how many responses are indicated by each dot (data = survey responses). And, I'd love it if the dots could become 3D column indications along with numbers shown, of the responses this column represents.
Thanks!
I have two sets of data I want to present on the same chart. The first set of numbers are all around 90, the second set are all around 12. I want to use a line graph where both lines are relatively close to each other. How do I have two different y axes so the lines on the graph are close to each other...ie not one line near the top of the chart and one near the bottom?
I have made a bar chart containing actual dollars on the y axis and months on
the x axis. I would like to add a line to the same chart which would
represent estimated dollars on the y and months on the x to compare the
actual to the estimate on the same chart. Is this possible?
Hi...
I know this is probably really, really basic, but I am so bad when it comes to using excel...currently I have 2 sets of data (I'll call them A and B, otherwise I'm going to have trouble explaining myself), each comprising of mass and excretion rate. How do I get both data sets in a scatter graph so that I can compare them, ie. excretion rate A plotted against mass A in one colour, and excretion rate B plotted against mass B in another?
At the moment I only know how to get all the excretion rates plotted against all the masses, in which case I can't find a way between differentiating between data sets A and B on the graph!
Thank you so much to anyone that can help me with this!
I have two sets of data and I need to put them in a column chart. Everything works great until I set the second set of data to a secondary y axis, then it places both columns directly on top of each other instead of side by side. How do I keep this from happening?
I want to show the number of people arriving at work between certain hours and the number of people departing work between certain hours on one chart - how do I do that?
lmeg
I have column A filled with 300 names. Column B has the persons quality score %. Column C has that persons AHT time. I am trying to create a scatter chart that will display the distribution of people into four quads. The people with high quality and low AHT etc. Can anyone help me. Maybe I am not explaining it well.
Thanks
I have three different data sets:
X number of sales for one particular item on various days at various prices
X number of sale for a different item on different days at different prices
and yet a third X number of sale for a particular item at different prices/days.
The prices and days sold are no too far apart, however, i want to show the trend of prices for each item on one chart. Help please.
