What kind of chart is this?

  • Thread starter Thread starter katzy
  • Start date Start date
K

katzy

I'm trying to create a certain kind of line chart and am having much
difficulty doing so.

Basically I'm trying to show the time employees are working for a company.

I want the X access to have the years and Y access to be the name of each
employee. Each employee's line color will depend on their race.

So far I've had no luck in creating this exact chart based on the drawing
you can find here: http://www.networkone-cns.com/helpimage.bmp

I've tried presenting the information in many different ways in excel in
hopes the axises will reflect correctly and that I can get straight,
horizontal lines.

Many thanks for your suggestions.
 
So far this has been the best chart. However I don't understand what you
mean by "invisible".

If I choose to remove the series all-together then it messes up the axis
values
 
I just changed the color so that there is none that you can see which looks
great on the graph itself. but it still shows up in the legend.
 
I just changed the color so that there is none that you can see which looks
great on the graph itself. but it still shows up in the legend.
Click to expand...

If you single click carefully twice on the legend entry (not too fast or
you'll "double click"), it selects just that legend. Then you can delete
it, leaving the other legends still showing.
 
Back
Top