tag:blogger.com,1999:blog-7413274486781112158.post8306208759659954331..comments2023-06-02T03:18:10.425-04:00Comments on Dan's .NET Blog: Excel Graphs with EPPlusDan Borishttp://www.blogger.com/profile/07071989815220997114noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-7413274486781112158.post-86789233907297520792020-06-01T03:38:14.393-04:002020-06-01T03:38:14.393-04:00Solved.
I don't know why but it is a problem ...Solved. <br />I don't know why but it is a problem of Font Size.<br />When I set the size, the Axis text appear.Alehttps://www.blogger.com/profile/02959852183997934360noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-29424229685453086642020-05-29T14:09:20.480-04:002020-05-29T14:09:20.480-04:00Looks like the problem is that the font color for ...Looks like the problem is that the font color for the Axis labels is being set to white by default, so you can't see the labels. You can fix this with:<br /><br /> chart.XAxis.Font.Fill.Color = System.Drawing.Color.Black;<br />Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-50998593706736859132020-05-29T08:52:13.884-04:002020-05-29T08:52:13.884-04:00You can get the axis labels back by setting the st...You can get the axis labels back by setting the style on the chart like this:<br /><br /> chart.StyleManager.SetChartStyle(OfficeOpenXml.Drawing.Chart.Style.ePresetChartStyle.BarChartStyle1);<br /><br />I haven't been able to figure out exactly what properties you would need to set on the chart to have the label appear without having to apply the style.Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-65602175912543984942020-05-29T04:24:30.923-04:002020-05-29T04:24:30.923-04:00Hello, with EPlus v5.1, the graph is plotted witho...Hello, with EPlus v5.1, the graph is plotted without axis labels.<br />Axis are present, ticks are there but no label for month and axis values.<br />I'm not able also in excel to set them visiible (or re-set them).<br />Do you know how to plot them?<br /> Alehttps://www.blogger.com/profile/02959852183997934360noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-56830773889397893242020-01-26T09:20:57.500-05:002020-01-26T09:20:57.500-05:00It doesn't give you total control of the posit...It doesn't give you total control of the position, but you can move it to different sides like this:<br /><br />chart.Legend.Position = eLegendPosition.Left;<br /><br />You can also allow it to overlay the legend over the graph like this:<br /><br />chart.Legend.Overlay = true;Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-71739682877369784482020-01-12T23:15:48.543-05:002020-01-12T23:15:48.543-05:00Hello,
There is option Available to Set the Chart ...Hello,<br />There is option Available to Set the Chart legend On Left Top Or anywhere of the chart?Ashraf Ali.https://www.blogger.com/profile/01797454346484164673noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-39457459660628220682016-12-13T16:30:13.424-05:002016-12-13T16:30:13.424-05:00Thanks! Do you know how I would add horizontal thr...Thanks! Do you know how I would add horizontal threshold lines using EPPlus? I found <a href="https://confluence.dimagi.com/pages/viewpage.action?pageId=29559951" rel="nofollow">this</a>, but idk how I would do it with EPPlus.hello1234https://www.blogger.com/profile/09798309322389890500noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-35690895667124273442016-11-14T05:18:25.062-05:002016-11-14T05:18:25.062-05:00How to Change Bar color in Bar ChartHow to Change Bar color in Bar Chartjanardhanhttps://www.blogger.com/profile/16558689063659484656noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-19795602380245451222016-06-21T20:39:58.998-04:002016-06-21T20:39:58.998-04:00Yep..
chart.XAxis.Title.Text = "Month"...Yep..<br /><br /> chart.XAxis.Title.Text = "Month";<br /> chart.YAxis.Title.Text = "Quantity Sold";<br /><br />You are also a bunch of other properties on Title that allow you to format the labels any way you want.Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-46787164523952820222016-06-20T17:37:05.940-04:002016-06-20T17:37:05.940-04:00Can I label the axes?Can I label the axes?hello1234https://www.blogger.com/profile/09798309322389890500noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-40720865405783760232016-06-17T16:58:17.251-04:002016-06-17T16:58:17.251-04:00The graph is drawn with default colors, but you ca...The graph is drawn with default colors, but you can change them. Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-17602222855402511172016-06-17T15:07:46.858-04:002016-06-17T15:07:46.858-04:00Do you pick the colors for the graph or is that so...Do you pick the colors for the graph or is that something you can setsteegejehttps://www.blogger.com/profile/11837293443368516391noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-12069710300517599192015-11-26T07:36:40.004-05:002015-11-26T07:36:40.004-05:00Yes, you can do it as I describe in the article by...Yes, you can do it as I describe in the article by setting the HeaderAddress property of the series to the cell where the name should come from.<br /><br />series.HeaderAddress = new ExcelAddress("'Sheet1'!C1");<br /><br />Or you can set the name directly with the Header property.<br /><br />series.Header = "Series1";Dan Borishttps://www.blogger.com/profile/07071989815220997114noreply@blogger.comtag:blogger.com,1999:blog-7413274486781112158.post-65897492519251195002015-11-26T04:19:13.745-05:002015-11-26T04:19:13.745-05:00is it possible to add series labels? How to do it?...is it possible to add series labels? How to do it?Anonymoushttps://www.blogger.com/profile/02870549213835490357noreply@blogger.com