Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to create a graph from my data, however the option I need to select based on my instructions is not available. "Under the paste icon in the home tab, select paste special, then select new series and categories (x values) in first column"
Solved by O. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/08/2018 - 01:37
Hi.. Welcome to Got It Pro
User
27/08/2018 - 01:37
hi
Excelchat Expert
27/08/2018 - 01:38
How can I help you today?
User
27/08/2018 - 01:38
I cannot find the option under paste special that I need to proceed in my lab
Excelchat Expert
27/08/2018 - 01:38
ok..
Excelchat Expert
27/08/2018 - 01:38
can you upload your file in here..??
User
27/08/2018 - 01:38
I need to select new series and categories (x values) in first column
Excelchat Expert
27/08/2018 - 01:39
so I can better assist you..
User
27/08/2018 - 01:39
just a moment
User
27/08/2018 - 01:41
im sorry it is not allowing me to attach it
Excelchat Expert
27/08/2018 - 01:42
ok..
Excelchat Expert
27/08/2018 - 01:43
then can you explain step by step what you want to do , I will try to replicate your situation on my computer..
Excelchat Expert
27/08/2018 - 01:46
what option are you trying to find under paste special?
Excelchat Expert
27/08/2018 - 01:48
if you want to see paste special,
Excelchat Expert
27/08/2018 - 01:48
first you need to copy cells ..
Excelchat Expert
27/08/2018 - 01:49
and select cell where do you want to paste..
Excelchat Expert
27/08/2018 - 01:49
and Alt+E key togather..
Excelchat Expert
27/08/2018 - 01:49
and hit E
Excelchat Expert
27/08/2018 - 01:50
sorry hit S..
Excelchat Expert
27/08/2018 - 01:50
Alt+E, S
Excelchat Expert
27/08/2018 - 01:50
Paste Special menu will pop up..
Excelchat Expert
27/08/2018 - 01:51
then you can select whatever you want.. and click OK..
Excelchat Expert
27/08/2018 - 01:51
Do you have any other questions.?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
