首页 > 解决方案 > MS Excel not showing the x values of my data

问题描述

screenshot

The x axis on the table is not showing the x-values I in my data. I want the corresponding date for each point directly below it.

Excel (2007) has just added random dates.

Any idea how I can get the correct dates to be shown?

标签: excel

解决方案


在您的图表工具下,转到“布局 -> 数据标签”并选择您满意的那个。该选项就在您的图表标题、轴、图例选项等处。

在此处输入图像描述

{抱歉,刚刚添加了我电脑上第一个打开的东西的图片}

享受...


推荐阅读