Good morning, does anyone knows if there's the possibility of doing a chart like the one attatched? They are three separete charts that i wanted to join and make one, because they all talk to each other and have a sharing axis in between them.
Capture.PNG
The picture looks to me like an average, run of the mill XY scatter chart with 7 data series. Without more detail, we cannot help with specifics. If you are unfamiliar with the basic mechanics of creating charts (including scatter charts), I would probably recommend starting here: https://support.microsoft.com/en-us/...rs=en-us&ad=us
Originally Posted by shg
Yes, thats it. Im usgin 3 data per graph right now, but i would want to go to 10 points.
I already did the three graphs, my problem is merging them in to one
Attachment 772141
Your attachment failed to attach. Be sure to follow the instructions in the yellow banner at the top of the page. There should be no difficulty in creating a scatter chart with more than 3 points and/or data series.
Attachment 772153
it follows
Still invalid attachment. Are you following these instructions?
Tried again.
Capture.PNG
Your latest shows a picture of 3 scatter charts (no spreadsheet data). I'm not certain exactly what problem you are having combining them into one chart? As far as chart mechanics goes, it should be as easy as adding each data series to a single chart.
Reading between the lines, I wonder if the main question is about the different scaling. The Y values for the upper right chart range from 5 to 45, but the Y values for the lower charts range from 1 to 6.5. The X values for the left chart range from 200 to 600, but the X values for the right two charts range from 0.3 to 0.8. Often, combining data series with very different values causes series with small values to be dwarfed by the series with large values. The solution (illustrated to some extent in this panel chart tutorial: https://peltiertech.com/Excel/Charts...venScales.html ) is to "tranform" or "scale" the raw data in the spreadsheet into values that will be more visually appealing in the chart. For examples, you might divide the X values for the lower left data by 1000, so that they are now similar to the X values for the other charts. You also could divide the Y values of the upper right chart by 10, so that they fit into the same 0 to 10 scale as the lower charts. If this is the question behind the question, then this is mostly just a trial and error process of coming up with a suitable tranformation/scaling formula for each data set that you want to add to the chart.
Are we getting closer to understanding the problem?
These three separate charts actually have different axis scales. To combine them you would have to tweak the values and the axes to make everything work out. You have to tell Excel what to do, it can't read your mind.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks