Hiding Secondary scales when there are multiple series being plotted...
Hi All,
I am displaying data on an Excel line chart. Y-Axis data are readings and X-Axis data are sampling DateTime stamps. I am able to plot the points correctly on the graph but now I want to scale the X-Axis values so that they represent the actual time. Right now the X-Axis data displays something like (38383, 38383.2, 38383.4, 38383.6, 38383.8, 38384, 38384.2). The numbers represent the number of days since 1/1/1900. Instead of these values I want to see Day Hours:Minutes format values such as 23 18:15 (meaning the 23rd day of the month at 6:15 PM).
One other problem is that I can not figure out how to hide the secondary scales on the right and top of the graph when there are multiple series being plotted.
Thanks in advance!
- Ishika
Hi All,
I am displaying data on an Excel line chart. Y-Axis data are readings and X-Axis data are sampling DateTime stamps. I am able to plot the points correctly on the graph but now I want to scale the X-Axis values so that they represent the actual time. Right now the X-Axis data displays something like (38383, 38383.2, 38383.4, 38383.6, 38383.8, 38384, 38384.2). The numbers represent the number of days since 1/1/1900. Instead of these values I want to see Day Hours:Minutes format values such as 23 18:15 (meaning the 23rd day of the month at 6:15 PM).
One other problem is that I can not figure out how to hide the secondary scales on the right and top of the graph when there are multiple series being plotted.
Thanks in advance!
- Ishika
Last edited: