Bonjour,

Pour un projet en devenir je dois utiliser un objet graphique pour réaliser des graphiques statistiques un peu spéciaux. J'aimerai savoir si l'objet que vous proposer correspond à ma demande.

Données à afficher dans le graphique :

Je n'ai pas de données entre 18h00 et 8h00 du matin. J'aimerai que un axe des X

avec un pas de 1 heure sauf entre 8h00 et 18h00 : 8h00,9,10,...18h00

un seul pas entre 18h00 et 8h00 le lendemain

ceci dans le cas ou j'ai des données sur plusieurs jours. Cela permet d'étendre la zone de visualisation des données de jour et de rétrécir la zone inutile de la nuit

L'affichage doit être sous forme de nuage de points ou de lignes.

Merci de votre aide. J'ai surtout besoin de savoir si cela est possible avec votre objet aspose.chart sour .net. Avec un exemple de préférence

Merci d'avance

Jacques TANTUCI

jtantucci@msn.com

jacques.tantucci@clf-dexia.com

Hi Jacques,

Could you try to explain your issue in English, so that we may understand well your problem.

Thank you.

I  do not have data between 18h00 and 8h00 of the morning. I will like that an x axis with a step of 1 a.m. except between 8h00 and 18h00: 8h00,9,10... 18h00 only one step between 18h00 and 8h00 the following day this in the case or I have data over several days. That makes it possible to extend the zone of visualization of the data of day and to narrow the useless zone of the night Posting must be in the form of line or group of dots. Thank you for your assistance. I need especially to know if that is possible with your object aspose.chart sour net. With an example preferably Thank you in advance

Jacques TANTUCI

jtantucci@msn.com

jacques.tantucci@clf-dexia.com

Dear Ben,

Thanks for the translation.I think I now understand Jacques query to certain extent.

Hi Jacques,

Thanks for considering Aspose.

Following example shows how to set interval of 1 hour b/w 8.00 - 18.00 hours in a given date for your reference. I utilized the curve line chart in this sample and the chart output is also attached.

Chart c = new Chart();
   c.Height = 900;
   c.Width = 1000;

   c.BackColor = Color.FromArgb(217, 224, 236);
   c.Titles.Add(new Title());
   c.Titles[0].Text = "Curve 2D, Hours Format Axis X";

   c.FrameBorder.BorderType = BorderType.Colonial;
   c.FrameBorder.BorderColor = Color.FromArgb(153, 204, 255);

   c.ChartArea.AxisX.IsAutoCalc = false;
   c.ChartArea.AxisX.DefaultLabel.FontAngle = 45;
   c.ChartArea.AxisX.DefaultLabel.Font = new Font("Arial",8);
   c.ChartArea.AxisX.Minimum = (new DateTime(2007,8,1,8,0,0)).ToOADate();
   c.ChartArea.AxisX.Maximum = (new DateTime(2007,8,1,18,0,0)).ToOADate();
   c.ChartArea.AxisX.DefaultLabel.Format = "h:mm";
   c.ChartArea.AxisX.IntervalType = IntervalType.DateTime; 
   c.ChartArea.AxisX.DateTimeIntervalType = DateTimeIntervalType.Hours;
   c.ChartArea.AxisX.Interval = 1; 
   
     
   Series s0 = new Series();
   s0.ChartType = ChartType.Curve; 
     
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,8,0,0)).ToOADate(),43000));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,8,30,0)).ToOADate(),29140));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,9,4,0)).ToOADate(),14790));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,9,33,0)).ToOADate(),36140));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,10,3,0)).ToOADate(),29480));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,10,34,0)).ToOADate(),31610));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,11,3,0)).ToOADate(),40230));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,11,34,0)).ToOADate(),36310));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,12,0,0)).ToOADate(),36420));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,12,30,0)).ToOADate(),20370));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,13,30,0)).ToOADate(),49530));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,15,4,0)).ToOADate(),15150));
   s0.DataPoints.Add(new DataPoint("point",(new DateTime(2007, 8, 1,15,34,0)).ToOADate(),16730));

   c.SeriesCollection.Add(s0);
   
   //Save the chart image into a memory stream.
   MemoryStream ms = new MemoryStream();
   c.Save(ms, ImageFormat.Png);

   //Save the chart image from the memory stream to the response.
   Response.Clear();
   Response.ContentType = "image/png";
   Response.OutputStream.Write(ms.ToArray(), 0, (int)ms.Length);

Thank you.

Hi Jacques,

Could you create your desired chart with your specified intervals spanned over 3 days in MS Excel manually and post the file here. We will check it soon.

Thank you.

Hi

I can not do this type of chart in Excel. That is why I seek another way. I sent you an example of what I want in an Excel spreadsheet, Tab 'Granularité réelle' Cell F78: R129. The chart at the top is automatically generated with Excel, the bottom is the one that I want

Thanks for your help

Jacques

Hi,

Thanks for further details.

Well, I think you may try to add multiple chart areas and specify the time intervals for each day's activity (i.e., 1,2,3).

May the following sample code help your for your requirement, I also attached the output chart image:

Chart c = new Chart();
   c.Height = 900;
   c.Width = 1300;

   c.BackColor = Color.FromArgb(217, 224, 236);
   c.Titles.Add(new Title());
   c.Titles[0].Text = "Line, Hours Format Axis X";
   c.ChartAreaLayout = LayoutType.Row;

   ChartArea a = null;
    
   
   
   for(int cnt = 0; cnt<2;cnt++)
   {
    a = new ChartArea(c);
    c.ChartAreas.Add(a);
   
   }
   

   for (int x = 0; x < 3; x++)
   {
       
       
      
    if(x ==0)
    {
     c.ChartAreas[x].LegendBox.IsVisible = false;
     c.ChartAreas[x].AxisX.IsAutoCalc = false;
     c.ChartAreas[x].AxisX.DefaultLabel.FontAngle = 45;
     c.ChartAreas[x].AxisX.DefaultLabel.Font = new Font("Arial",8);
     c.ChartAreas[x].AxisX.Minimum = (new DateTime(2007,8,1,8,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.Maximum = (new DateTime(2007,8,1,18,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.DefaultLabel.Format = "h:mm";
     c.ChartAreas[x].AxisX.IntervalType = IntervalType.DateTime; 
     c.ChartAreas[x].AxisX.DateTimeIntervalType = DateTimeIntervalType.Hours;
     c.ChartAreas[x].AxisX.Interval = 1;
     c.ChartAreas[x].Name = "Area1";
 
     
    }
     
    
    if(x ==1)
    {
     c.ChartAreas[x].LegendBox.IsVisible = false;
     c.ChartAreas[x].AxisX.IsAutoCalc = false;
     c.ChartAreas[x].AxisX.DefaultLabel.FontAngle = 45;
     c.ChartAreas[x].AxisX.DefaultLabel.Font = new Font("Arial",8);
     c.ChartAreas[x].AxisX.Minimum = (new DateTime(2007,8,2,8,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.Maximum = (new DateTime(2007,8,2,18,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.DefaultLabel.Format = "h:mm";
     c.ChartAreas[x].AxisX.IntervalType = IntervalType.DateTime; 
     c.ChartAreas[x].AxisX.DateTimeIntervalType = DateTimeIntervalType.Hours;
     c.ChartAreas[x].AxisX.Interval = 1;
     c.ChartAreas[x].Name = "Area2";
     
     
    }

    if(x ==2)
    {
     c.ChartAreas[x].LegendBox.IsVisible = false;
     c.ChartAreas[x].AxisX.IsAutoCalc = false;
     c.ChartAreas[x].AxisX.DefaultLabel.FontAngle = 45;
     c.ChartAreas[x].AxisX.DefaultLabel.Font = new Font("Arial",8);
     c.ChartAreas[x].AxisX.Minimum = (new DateTime(2007,8,3,8,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.Maximum = (new DateTime(2007,8,3,18,0,0)).ToOADate();
     c.ChartAreas[x].AxisX.DefaultLabel.Format = "h:mm";
     c.ChartAreas[x].AxisX.IntervalType = IntervalType.DateTime; 
     c.ChartAreas[x].AxisX.DateTimeIntervalType = DateTimeIntervalType.Hours;
     c.ChartAreas[x].AxisX.Interval = 1;
     c.ChartAreas[x].Name = "Area3";
     
 
    }
    
       
    
 &