Thread: Line graphs and the vertical axis
View Single Post
 
Old 10-18-2018, 08:05 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by texascpa View Post
Attached is my spreadsheet with a line graph. Go to the 2nd worksheet and you will find my question about the vertical axis. I do not know where that information came from that is on the vertical axis of the graph. I want the information that is in Col. A on the vertical axis. How do I do that. Need an answer ASAP.

Thanks for your help

While inside the chart, click design tab, then the select data tools. change $b$1 to $a$1, OK. Add or remove legends (Num, Date, Dia, Sys). You may switch vertical and horizontal axis.
Attached Files
File Type: xlsx Copy of 1HEARTxlsx.xlsx (15.4 KB, 9 views)
Reply With Quote