SOLVED

Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-895640%22%20slang%3D%22en-US%22%3ECharts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895640%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20create%20a%20dual%20serious%20chart%20with%20same%20horizontal%20time%20axis%20if%20each%20data%20set%20contains%20in%20horizontal%20axis%20(x)%20different%20time%20events.%20for%20example%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3Ex%20axis%3C%2FTD%3E%3CTD%3Ey%20axis%3C%2FTD%3E%3CTD%3Ex%20axis%3C%2FTD%3E%3CTD%3Ey%20axis%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.03%2015%3A45%3A00%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E2019.01.03%2015%3A00%3A00%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.03%2017%3A00%3A00%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E2019.01.03%2017%3A05%3A00%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.03%2018%3A15%3A00%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3CTD%3E2019.01.03%2018%3A10%3A00%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.04%2009%3A15%3A00%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E2019.01.04%2009%3A25%3A00%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.04%2011%3A00%3A00%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E2019.01.04%2011%3A35%3A00%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.04%2015%3A44%3A57%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3CTD%3E2019.01.04%2015%3A55%3A00%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019.01.04%2015%3A44%3A57%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E2019.01.04%2015%3A59%3A00%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-895640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895766%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420877%22%20target%3D%22_blank%22%3E%40Ilan_S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20scatter%20chart%20adding%20series%20one%20by%20one.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20457px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135614iC18D07CF8A38981B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-896212%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20plot%20the%20scatter%20chart%2C%20but%20I%20have%20problem%20seeing%20the%20right%20dates%20in%20the%20horizontal%20axis.%20I%20tried%20to%20define%20the%20exact%20format%20code%20of%20the%20date%20under%20format-Axis%2FNumber%2FFormat%20code%2C%20and%20still%20receive%20the%20wrong%20dates.%20The%20format%20that%20I%20use%20is%20as%20follow%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E2019.10.03%2023%3A59%3A59%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E2019.10.03%2023%3A59%3A59%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E2019.10.03%2023%3A59%3A59%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E2019.10.03%2023%3A59%3A59%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3BThe%20format%20code%20that%20I%20defined%20is%20yyyy.mm.dd%20hh%3Amm%3Ass.%20On%20the%20chart%20I%20see%20the%20following%3A%3C%2FP%3E%3CP%3E1900.10.03%2000%3A00%3A00.%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20doing%20something%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-897591%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420877%22%20target%3D%22_blank%22%3E%40Ilan_S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20I%20copy-pasted%20table%20from%20your%20post%20dates%20were%20as%20texts%20(I%20have%20bit%20another%20format)%3C%2FP%3E%0A%3CP%3EIf%20convert%20to%20dates%20it%20works.%20Select%20your%20first%20block%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20235px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135681i58CCDF12A0EC5E90%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20add%20scatter%20chart%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135682i312BF0DCBE17544E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAfter%20that%20select%20second%20block%2C%20copy%20it%2C%20click%20on%20chart%20area%20and%20Paste%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20413px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135683i64469A9814F91FF0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOn%20x-axis%20you%20have%20your%20dates.%20After%20that%20cosmetic%20with%20x-axis%20values%20formatting%20and%20margins%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20432px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135684i9CE7FA7302C58216%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThus%20as%20a%20first%20step%20check%20if%20you%20have%20datetime%2C%20not%20text%20representation%20of%20it.%20As%20variant%2C%20by%20%3DISTEXT()%20in%20any%20empty%20cell%20on%20any%20of%20your%20datetime.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516480%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516480%22%20slang%3D%22en-US%22%3EI%20need%20the%20same%20chart%3CBR%20%2F%3EThe%20Variance%20between%20each%20column%20and%20the%20Other%20one%20to%20be%20on%20the%20top%20as%20the%20same%20chart%20I%20submit%20and%20automatically%20up%20date%20and%20the%20line%20which%20link%20those%20variances%20lapel%20is%20generated%20automatically%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516483%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516483%22%20slang%3D%22en-US%22%3EGet%20any%20figures%20but%20should%20be%20column%20chart%20and%20get%20the%20variances%20and%20I%20need%20in%20excel%20and%20every%20thing%20should%20come%20automatically%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516484%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516484%22%20slang%3D%22en-US%22%3EI%20need%20it%20on%20column%20chart%20please%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516489%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20not%20what%20I%20am%20looking%20for%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516491%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516491%22%20slang%3D%22en-US%22%3EThank%20you%20this%20not%20what%20I%20need%20to%20be%20done%3C%2FLINGO-BODY%3E
New Contributor

How can create a dual serious chart with same horizontal time axis if each data set contains in horizontal axis (x) different time events. for example:

x axisy axisx axisy axis
2019.01.03 15:45:0022019.01.03 15:00:004
2019.01.03 17:00:0032019.01.03 17:05:003
2019.01.03 18:15:0042019.01.03 18:10:002
2019.01.04 09:15:0052019.01.04 09:25:001
2019.01.04 11:00:0062019.01.04 11:35:005
2019.01.04 15:44:5772019.01.04 15:55:006
2019.01.04 15:44:5782019.01.04 15:59:007

 

8 Replies
Best Response confirmed by Ilan_S (New Contributor)
Solution

@Ilan_S 

You may use scatter chart adding series one by one.

image.png

 

@Sergei Baklan 

 

Hi

I am trying to plot the scatter chart, but I have problem seeing the right dates in the horizontal axis. I tried to define the exact format code of the date under format-Axis/Number/Format code, and still receive the wrong dates. The format that I use is as follow:

2019.10.03 23:59:59
2019.10.03 23:59:59
2019.10.03 23:59:59
2019.10.03 23:59:59

 The format code that I defined is yyyy.mm.dd hh:mm:ss. On the chart I see the following:

1900.10.03 00:00:00. 

Am I doing something wrong?

@Ilan_S 

When I copy-pasted table from your post dates were as texts (I have bit another format)

If convert to dates it works. Select your first block here

image.png

and add scatter chart

image.png

After that select second block, copy it, click on chart area and Paste

image.png

On x-axis you have your dates. After that cosmetic with x-axis values formatting and margins

image.png

Thus as a first step check if you have datetime, not text representation of it. As variant, by =ISTEXT() in any empty cell on any of your datetime.

I need the same chart
The Variance between each column and the Other one to be on the top as the same chart I submit and automatically up date and the line which link those variances lapel is generated automatically
Get any figures but should be column chart and get the variances and I need in excel and every thing should come automatically
I need it on column chart please

@Sergei Baklan 

 

this is not what I am looking for 

 

Thank you this not what I need to be done