I have to put several datas in a graph.
I have 3 different groups on the y-axis and about 6 on the x-axis.
Only problem is that 5 of the 6 group on the x-axis have a variable that differs anywhere from 0 to 25 and 1 group that has variables differen from 100 to 5000.
So basically every variable of the other 5 groups looks like zero because the 5000-variable is so large.
Anybody knows any possible solutions?
I was thinking about an interval of the y axis making it ranges from 0 to 25, covering about 75 percent of the graph, and that the rest is from 25 to 5000, covering up the other 25 percent of the size of the y graph ( so like a different scale and interval) .
Is that possible in Excel and how?
I'm nothing close to a pro in Excel, one could call me a rookie.
Thanks a lot in advance!
Bookmarks