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
Highlighted
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
Highlighted
Solution

@Ilan_S 

You may use scatter chart adding series one by one.

image.png

 

Highlighted

@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?

Highlighted

@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
Automatic coloring sunburst chart
stefan645 in Excel on
2 Replies
Error in Excel : All the charts are removed
eecstuttgart in Excel on
4 Replies
Chart from a calendar
EddTillen in SharePoint on
1 Replies
Donut/Doughnut Chart - Multiple Series
lwilkinson92 in Excel on
0 Replies