Hi,
I have 18 graph data and i want to move that data to graph similar to this image. Any idea how to do that? Appreciate your help.
Thanks.
IMG_1951.jpg
Hi,
I have 18 graph data and i want to move that data to graph similar to this image. Any idea how to do that? Appreciate your help.
Thanks.
IMG_1951.jpg
Both charts look like basic XY scatter charts.
For the second chart:
1) Select G2:H23 -> Insert Scatter chart.
2) Excel's default behavior will be to use the left column (column G) for the Xvalues and the right column(s) for the Y values, so go into the Select data dialog and switch the X and Y values.
The procedure for the first chart is the same, except that all your data entries are text strings, so you will need to edit them to change them to real numbers.
Originally Posted by shg
Hi MrShorty,
I'm not familiar to the graph in Excel. How to edit Y and X axis to the real number?
Thanks.
Oh i think i get what you mean. need to convert it to number right. thanks. i will try to do that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks