Excel line graphs - legends generated incorrectly

  Рет қаралды 256

Ron Lembke

Ron Lembke

Жыл бұрын

I was making an Excel graph out of data with many rows and columns, and Excel would not properly generate the legend.
Excel got confused because there was a word in the top left corner of my data that said "Years," above the column with the numbers 1998-2022.
Excel treated that column as if those were numbers to be graphed, even though all of the other numbers are around 100,000,000.
Once I deleted that word "Years," Excel properly generates the labels in the legend.
This may not help many people, but it sure took me a long time to figure out. But maybe I'm just slow.

Пікірлер: 1
@marypitman2713
@marypitman2713 3 ай бұрын
OMG! Thank you! Similar but different problem, I did not have a header above my data column (or the label column). My labels were part of the graph data but excel labeled each item in the legend as 1,2,3,4,etc.
Is your line chart lying? 4 ways to correctly chart disparate data.
6:05
MyOnlineTrainingHub
Рет қаралды 11 М.
How To Make A Line Graph In Excel-EASY Tutorial
2:36
Helpful DIY
Рет қаралды 4,6 МЛН
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 39 МЛН
How to Make a Gantt Chart in Excel
12:54
Vertex42
Рет қаралды 3,6 МЛН
Extracting data from a graph using ScanIt from Amsterchem
13:07
Slopegraphs in Excel
7:15
Ron Lembke
Рет қаралды 130
Using the Excel Data Types Tools
6:49
Technology for Teachers and Students
Рет қаралды 70 М.
Excel Solver & Goal Seek Tutorial
23:34
Kevin Stratvert
Рет қаралды 158 М.