Tjyylli

How does Leonard in "Memento" remember reading and writing?

Positioning node within rectangle Tikz

The use of the spellings -zz- vs. -z-

What is a good reason for every spaceship to carry a weapon on board?

What is the most fuel efficient way out of the Solar System?

How would an AI self awareness kill switch work?

Salesforce package error error “You can't specify version for namespace sf_com_apps because this namespace is not installed to your organization.”

Why did Democrats in the Senate oppose the Born-Alive Abortion Survivors Protection Act (2019 S.130)?

Flipping axis on a LogPlot

Play Zip, Zap, Zop

Is there a weight limit to Feather Fall?

Calculate the number of points of an elliptic curve in medium Weierstrass form over finite field

How much mayhem could I cause as a sentient fish?

How to make ice magic work from a scientific point of view?

How to deal with an incendiary email that was recalled

Why don't hotels mount air conditioning units outside the rooms?

It took me a lot of time to make this, pls like. (YouTube Comments #1)

Finding a logistic regression model which can achieve zero error on a training set training data for a binary classification problem with two features

What is the wife of a henpecked husband called?

Why publish a research paper when a blog post or a lecture slide can have more citation count than a journal paper?

What would be the rarity of this magic item(s)?

Using only 1s, make 29 with the minimum number of digits

In Linux what happens if 1000 files in a directory are moved to another location while another 300 files were added to the source directory?

How can a school be getting an epidemic of whooping cough if most of the students are vaccinated?

macOS Excel 16 doesn't support DateTime x-axis for XY-Scatter charts

Lines over data in Excel 2007 Scatter GraphHow to combine Excel charts on same X-axisHow to display US format date time in csv file in UK format in Excel 2010?Add an area to a scatter plot in ExcelExcel - X-axis issues when combining x-y scatter and column chartsHow to flip X and Y axes in Excel scatter chart with more than one seriesWhy is my Excel chart grouping all my x-axis time values at 0:00?Excel scatter plot x axis displays only sequential numbers but not real data selected for x axisAutomatic formatting of axis in Excel stacked bar chart to start at start date?Excel 2016 Chart showing random dates in x axis

0

I recently realized that Excel for Mac doesn't support DateTime x-axis for XY-Scatter charts. I do remember it previously does.

Below is the screenshot to illustrate this issue

1. It seems Excel doesn't honor the raw/literal value of the first column, it just assume the x-axis starts with 0 and the maximum value is 30,000


2. There is no way to customize it in the panel of (Format Axis->Axis Options->Number)


3. I tried to set the format of the first column to be either Date/Time/General/Text/Custom, none of it works

I've installed version 16.16.7 of Microsoft@Excel for Mac

macos microsoft-excel

share

asked 9 mins ago

machinariummachinarium

101

add a comment | 

0

I recently realized that Excel for Mac doesn't support DateTime x-axis for XY-Scatter charts. I do remember it previously does.

Below is the screenshot to illustrate this issue

1. It seems Excel doesn't honor the raw/literal value of the first column, it just assume the x-axis starts with 0 and the maximum value is 30,000


2. There is no way to customize it in the panel of (Format Axis->Axis Options->Number)


3. I tried to set the format of the first column to be either Date/Time/General/Text/Custom, none of it works

I've installed version 16.16.7 of Microsoft@Excel for Mac

macos microsoft-excel

share

asked 9 mins ago

machinariummachinarium

101

add a comment | 

I recently realized that Excel for Mac doesn't support DateTime x-axis for XY-Scatter charts. I do remember it previously does.

Below is the screenshot to illustrate this issue

1. It seems Excel doesn't honor the raw/literal value of the first column, it just assume the x-axis starts with 0 and the maximum value is 30,000


2. There is no way to customize it in the panel of (Format Axis->Axis Options->Number)


3. I tried to set the format of the first column to be either Date/Time/General/Text/Custom, none of it works

I've installed version 16.16.7 of Microsoft@Excel for Mac

macos microsoft-excel

share

asked 9 mins ago

machinariummachinarium

101

share

asked 9 mins ago

machinariummachinarium

101

share

asked 9 mins ago

machinariummachinarium

101

asked 9 mins ago

machinariummachinarium

101

asked 9 mins ago

machinariummachinarium

101