PrimaryCategoryAxis formatting when Category is a DateTime

[jcostello]

Hello,

I'm evaluating the free Spire.Presentation version 4.11.12.10040 and trying to create a line chart in a PowerPoint document. I have most of it working except for the following 2 issues:

1) When I open the PowerPoint presentation, the dates shown on the axis are not my Category dates - they start at '96 instead of '91 (see attached screenshot: incorrect_dates_1.png). But if I then right-click on the chart and select "Edit Data" the Category dates change to the correct years, almost like they are refreshed? (see attached screenshot: date_years_now_correct_2.png). Note that the month is shown as Jan when it should be Dec (see attached screenshot: month_still_incorrect_3.png).
2) Even after the dates have been updated, the Major Unit Value is not set based on the fact that it is still "Auto". The code sets both the BaseUnitScale (which looks like it was set) and the MajorUnitScale / MajorUnit (see attached screenshot: major_unit_not_set_4.png)

I have also attached the code I am using for reference (see attached test.cs).

Thank you!
John

[Betsy.jiang]

Hi,

Thanks for your inquiry.
I have noticed the issues and posted it to our Dev team. We will let you know as soon as there is any update.
Sorry for the inconvenience caused.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Thanks for waiting.
Now the issue is solved in Spire.Presentation Pack Hotfix Version:4.12.13.
Our website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.Pr ... on/4.12.13

Note if you want that the month displays correctly, you need to change ChartBaseUnitType as month.

Code: Select all

            chart.PrimaryCategoryAxis.BaseUnitScale = Spire.Presentation.Charts.ChartBaseUnitType.Months;

Sincerely,
Betsy
E-iceblue support team

[jcostello]

Thanks Betsy, this looks great!

Do you know if there will eventually be a fix so that the Label dates will actually be the Month-Date of the the data points - even if we want to show Labels only every 3 years? For example, if I have only March dates then the chart would show the corresponding March date every 3 years. We are currently doing this with Excel charting using Epplus and I think the executive team has grown accustomed to it.

Thanks again!
John

[Betsy.jiang]

Hi John,

According to your information, I think you could add the data labels you want. Please try to use following code:

Code: Select all

            for (int i = 0; i < chart.Series.Count; i++)
            {
                ChartSeriesDataFormat series = chart.Series[i];
                for (int j = 0; j < series.Values.Count; j = j + 3 )
                {
                    ChartDataLabel label = series.DataLabels.Add();
                    label.ID = j;
                    label.LabelValueVisible = true;
                }
            }

If this doesn't meet your requirement, please provide the desired PPT file for further investigation.

Sincerely,
Betsy
E-iceblue support team

[jcostello]

Thanks for the quick response Betsy!

It looks like the Series Data Labels are actually the labels for the data points along the line itself (not the text labels along the Category axis below). I've added your code snippet and attached the resulting PowerPoint.

Thanks - John

[Betsy.jiang]

Hi,

Thanks for your response.
Yes, the data label is for the data points along the line itself. It seems you want to add the custom text. Please refer to following code to change the datalabel:

Code: Select all

                for (int j = 0; j < series.Values.Count; j = j + 3 )
                {
                    ChartDataLabel label = series.DataLabels.Add();
                    label.ID = j;
                    label.LabelValueVisible = true;
                    //Change the datalal to the text you want
                    label.TextFrame.Paragraphs[0].Text = "Changed";
                }

If you still have the issue, please provide a desired result(You could create it by MS PowerPoint) for further investigation.

Sincerely,
Betsy
E-iceblue support team

[jcostello]

Thanks Betsy,

I was really trying to just get the Category Label to show every 3 years, but have the Month part of the date still display correctly. I realized from the previous post that I could do this by changing the Base Unit type to Months, and then specify a MajorUnit of 36 instead of 3 (when the Base Unit was years).

So I'm all set now. Thanks so much for assisting me with this!

- John

[Betsy.jiang]

Hi John,

Glad to hear that you have managed to solve your issue.
If there is any question while using our product, please feel free to contact us.

Sincerely,
Betsy
E-iceblue support team