SOLVED

Excel Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-1810090%22%20slang%3D%22en-US%22%3EExcel%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1810090%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20totally%20new%20to%20using%20excel%20since%20I'm%20a%20nurse%20by%20profession.%20I%20need%20help%20trying%20to%20create%20a%20combo%20graph%20with%20both%20monthly%20and%20quarterly%20data%20points.%20Whenever%20I%20insert%20graph%20I%20can't%20seem%20to%20get%20the%20orange%20line%20to%20plot%20(Magnet%20Mean.)%20Can%20anyone%20help%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tess_v_0-1603394776619.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228559iD6AA3BAEB6F3B30E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tess_v_0-1603394776619.png%22%20alt%3D%22tess_v_0-1603394776619.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1810090%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1810289%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1810289%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F842740%22%20target%3D%22_blank%22%3E%40tess_v%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%20problem%20here%20is%20that%20there%20are%20not%20as%20many%20data%20points%20for%20the%20line%20as%20there%20are%20for%20the%20columns%2C%20so%20you%20need%20to%20format%20the%20line%20to%20connect%20data%20points.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EInstead%20of%20using%20merged%20cells%2C%20it%20would%20be%20much%20better%20to%20enter%20the%20magnet%20mean%20into%20the%20middle%20cell%20of%20the%20three%20column%20block.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENext%2C%20chart%20the%20whole%20data%20as%20a%20line%20chart%20with%20two%20line%20series.%20Now%2C%20in%20the%20Chart%20Design%20ribbon%2C%20click%20%22Select%20Data%22%2C%20then%20click%20the%20button%20%22hidden%20and%20empty%20cells%22%20and%20select%20the%20option%20%22Connect%20data%20points%20with%20line%22.%26nbsp%3B%20That%20option%20is%20greyed%20out%20in%20a%20combination%20or%20a%20column%20chart%2C%20but%20you%20can%20select%20it%20in%20a%20line%20chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20chart%20now%20shows%20blue%20and%20orange%20lines.%20Next%2C%20change%20the%20chart%20type%20to%20a%20combination%20chart%20and%20plot%20the%20blue%20data%20as%20column.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-10-23_9-20-16.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228571i9B7F36194A716508%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222020-10-23_9-20-16.png%22%20alt%3D%222020-10-23_9-20-16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%20me%20know%20if%20that%20helps%20or%20if%20you%20need%20more%20info.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm totally new to using excel since I'm a nurse by profession. I need help trying to create a combo graph with both monthly and quarterly data points. Whenever I insert graph I can't seem to get the orange line to plot (Magnet Mean.) Can anyone help? 

tess_v_0-1603394776619.png

 

2 Replies
Best Response confirmed by tess_v (New Contributor)
Solution

Hello @tess_v ,

 

the problem here is that there are not as many data points for the line as there are for the columns, so you need to format the line to connect data points.

 

Instead of using merged cells, it would be much better to enter the magnet mean into the middle cell of the three column block.

 

Next, chart the whole data as a line chart with two line series. Now, in the Chart Design ribbon, click "Select Data", then click the button "hidden and empty cells" and select the option "Connect data points with line".  That option is greyed out in a combination or a column chart, but you can select it in a line chart.

 

The chart now shows blue and orange lines. Next, change the chart type to a combination chart and plot the blue data as column. 2020-10-23_9-20-16.png

 

Let me know if that helps or if you need more info.

Thank you so much for your help. I appreciate it!