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
Ilan_S
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

 

3 Replies
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.

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