Home

Excel Chart Help

%3CLINGO-SUB%20id%3D%22lingo-sub-359526%22%20slang%3D%22en-US%22%3EExcel%20Chart%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359526%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20a%20difficult%20time%20building%20a%20chart%20in%20Excel%2C%20and%20I%20was%20looking%20for%20some%20help%20from%20you%20talented%20users!%20I'm%20hoping%20it's%20an%20easy%20solution%20that%20I'm%20simply%20overlooking%2C%20but%20I%20haven't%20really%20worked%20with%20charts%20since%20college.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20collecting%20data%20(mm%3Ass)%20on%20how%20long%20people%20are%20talking%20on%20a%20stage%20at%20different%20locations%20for%20the%20company%20I%20work%20for%20and%20I'd%20like%20to%20build%20a%20chart%20that%20shows%20the%20various%20times%20(18%3A00%20to%2035%3A00)%20at%20various%20locations%20(1%20-%206)%20plotted%20on%20a%20date%2Ftime%20chart.%20I'd%20like%20each%20location%20to%20be%20a%20different%20%22series%22%20which%20I%20was%20able%20to%20get...but%20I%20can't%20seem%20to%20get%20any%20information%20to%20populate%20in%20the%20actual%20chart.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84926i3AC8091123533457%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-03-03%20at%2012.03.46%20PM.png%22%20title%3D%22Screen%20Shot%202019-03-03%20at%2012.03.46%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20different%20charts%2C%20cell%20formats%2C%20help%20videos%20and%20I'm%20finally%20at%20a%20point%20that%20I%20don't%20know%20what%20else%20to%20try.%20Could%20someone%20give%20me%20a%20hand%20or%20point%20me%20in%20the%20right%20direction%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359831%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359831%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20At%20first%20I%20thought%20it%20was%20because%20your%20time%20values%20were%20set%20as%20text%20and%20not%20time%2C%20but%20I%20still%20couldn't%20get%20them%20to%20plot%20after%20changing%20the%20format.%20In%20the%20end%20I%20changed%20your%20time%20to%20decimal%20numbers%20and%20that%20plotted%20OK.%20%26nbsp%3BHave%20attached%20your%20spreadsheet%20so%20you%20can%20see%20what%20I%20did.%3C%2FP%3E%3C%2FLINGO-BODY%3E
tylerwingo
Occasional Visitor

Hello,

 

I'm having a difficult time building a chart in Excel, and I was looking for some help from you talented users! I'm hoping it's an easy solution that I'm simply overlooking, but I haven't really worked with charts since college.

 

I'm collecting data (mm:ss) on how long people are talking on a stage at different locations for the company I work for and I'd like to build a chart that shows the various times (18:00 to 35:00) at various locations (1 - 6) plotted on a date/time chart. I'd like each location to be a different "series" which I was able to get...but I can't seem to get any information to populate in the actual chart.

Screen Shot 2019-03-03 at 12.03.46 PM.png

 

I've tried different charts, cell formats, help videos and I'm finally at a point that I don't know what else to try. Could someone give me a hand or point me in the right direction? 

1 Reply

Hi, At first I thought it was because your time values were set as text and not time, but I still couldn't get them to plot after changing the format. In the end I changed your time to decimal numbers and that plotted OK.  Have attached your spreadsheet so you can see what I did.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies