Hiding secondary scales when multiple series are being plotted...

F

Fibi

Hi All,

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.

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).

The scaling values I have at the bottom of the X-Axis (representing the
date range 2/2/2005 5:30:00 AM to 2/2/2005 11:30:00 PM ). I got these
values by subtracting the reading values from 01/01/1900 00:00:00. Now
I want to convert them back to the DD HH:MM format.

I'm using C# - ASP.NET Web Service to generate the chart.

Any help will be appreciated!

- Fibi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Employee Schedule not plotting properly - chart type / data series not correct 0
x-axis scaling 5
x-axis scaling 4
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Overlaying 2 Data Series with Different Time (X) Axis 3
adding trendline to plots from multiple series 1
Chart - Secondary Y-axis with different values/scale 2
Multiple yaxis, multiple scales, multiple series on each 1

Top