Line graphs and the vertical axis

Marcia · #2 10-18-2018, 08:05 PM

Quote:

Originally Posted by texascpa

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump	jcyo233	Excel	6	10-18-2018 04:49 AM
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect.	jalea148	Excel	3	01-06-2017 09:04 AM
How to set specific axis values in graphs	Esaylikepie	Excel	0	10-16-2016 04:31 AM
Vertical Axis Text Issue	word perfect	Excel	2	03-20-2013 02:23 PM
y axis on bar graphs	crbuckjr	PowerPoint	2	08-29-2012 06:25 AM