Line Chart with Sales by Person by Day

dmcgetti

Board Regular
Joined
Feb 16, 2015
Messages
66
I am sure that there is a super simple solution, but I am drawing a complete blank...

I have my table set up like so:

Employee2020-05-012020-05-042020-05-05
employee1$100$75$125
employee2-$25$50$200

I would like to create a chart that has the employee names on the vertical axis on the left, dollar scale on the right vertical axis and the dates on the horizontal axis.

When I us the default line chart in Excel, it has the employees along the horizontal axis, dollar scale on the left vertical axis and the dates as 2 separate value lines.

I know I am going to kick myself when i hear the answer, but I have already pulled out what little hair I have left... TIA!
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
1,020
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Why would you need the name on the Axis?
How would such a chart look like?

Doesn't this do?
- The legend is redundant, so can be deleted
- Left Axis is "High" so it appears at the right
- X-Axis is "Low" so it appears at the bottom (since there are negative values)
- First value is labelled, with the label on "Name"
1588871247923.png
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,983
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
G - good attempt to decipher the objective.
 

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
1,020
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Kind of you to say, Mr. Jon, coming from you that means a lot.

I hope the objective gets clarified by the OP. It is often hard for people to express their need, so they express a "want". Guessing for the moment.

I'm sure you would be asking critical questions I'm far from thinking about. The blog discussion you sometimes have with Chandoo or Jorge are beyond my comprehension. It made me realize charting and data visualization is truly a metier (pardon my French). The level of elements and details you all spot and consider are so insightful it may hurt the heart fainted. It has made me a better professional. #Grateful.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,983
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
It's the difference between being familiar with something, and being immersed in it. You see things, you remember things, and you know things.
 

Forum statistics

Threads
1,147,474
Messages
5,741,341
Members
423,656
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top