quick: calling all excel nerds

CosmicPathos

Anathema
Messages
3,923
Reaction score
530
Gender
Male
Religion
Islam
salam

I need some help with microsoft excel charts/graphs. Hopefully some of you here might know more about it.

I want to create a chart with two categories on x axis, lets say "A" and "B".

Now within each category I have a number of numerical values ranging from 1-20. I'd like to plot these numerical values on y axis. I want to see the plot as individual data points in the graph area within the two categories on x axis, not as a column graph or bar graph!

Excel has options for column graph but the problem with columns is that each column representing each numerical value extends up from the x axis to reach its position on y axis. This is messy and not the way I want to present my data.

Any helps? Any other better charting software?

Scimi bro, any ideas?
 
Last edited:
wsalam,

scatter graphs do show individual data points but the problem with scatter graph is that both x and y axis need to have quantitative data. There simply is no place for "categorical" organization.

My data on x-axis needs to just have categories and all numerical values in y axis.

Anyone?
 
41 views, and a lot of help. :D

allhamdulilllah, I was able to figure it out. Just assigned a numerical value to categories and then drew scatter plots.

jazaks to anyone who helped.
 
I think you can do this kind of stuff on minitab
 

Similar Threads

Back
Top