You can use moment.js to get the values formatted, but Highcharts has it’s own date formatting functionality which would be more idiomatic with Highcharts. It can be attached onto the tooltip option in the highcharts constructor like so: tooltip: { formatter: function() { return ‘<b>’ + this.series.name +'</b><br/>’ + Highcharts.dateFormat(‘%e – %b – %Y’, new … Read more
To do that we code one of the Paint events: Here the ValueToPixelPosition functions are valid and provide us with the necessary conversion between the DataPoint values and Chart pixels..: private void chart1_Paint(object sender, PaintEventArgs e) { // we assume two series variables are set..: if (sps1 == null || sps2 == null) return; // … Read more
To convert chart values to pixels you can use method NumberAxis#getDisplayPosition() which return actual coordinates of the chart nodes. Although these coordinates are relative to chart area, which you can find out by next code: Node chartArea = chart.lookup(“.chart-plot-background”); Bounds chartAreaBounds = chartArea.localToScene(chartArea.getBoundsInLocal()); Note localToScene() method which allows you to convert any coordinates to Scene … Read more
Offset function dynamic range makes it possible. Sample data Steps Define a dynamic named range =OFFSET(Sheet1!$A$2,,,1,COUNTA(Sheet1!$A$2:$Z$2)) and give it a name mobileRange Right Click on Chart Click on Select Data This screen will come Click on Edit under Legend Entries.(mobiles is selected) change the Series value to point to mobileRange named range. Now if data … Read more
Using: ActiveWorkbook.Sheets(“Sheet1”).ChartObjects(“Chart1”).Chart.SeriesCollection(1) Color of each point is .Points(PointNumber).Interior.Color The number of points you have to cycle though is .Points.Count The value of each point is .Points(PointNumber).Value colors of the markers themselves (Applies only to line, scatter, and radar charts): .Points(PointNumber).MarkerBackgroundColor = RGB(0,255,0) ‘ green .Points(PointNumber).MarkerForegroundColor = RGB(255,0,0) ‘ red .Points(PointNumber).MarkerStyle = xlMarkerStyleCircle ‘ change the … Read more
Thanks to NwDx’s answer I managed to create something useful. It’s not a complete chart application and I hope someone with more know how can provide a better answer, but I’ll post the result nontheless. You can use mouse dragging for rotation and mouse wheel for zooming. The example shows a perlin noise graph with … Read more
I have not used BIRT or JGraph, however I use JFreeChart in my SWT application. I have found the best way to use JFreeChart in SWT is by making a composite an AWT frame and using the AWT functionality for JFreeChart. The way to do this is by creating a composite Composite comp = new … Read more
Yes. You can assign arrays to the XValues and Values properties of a Series object on a chart. Example: Dim c As Chart Dim s As Series Dim myData As Variant Set c = ActiveChart ‘ Assumes a chart is currently active in Excel… Set s = c.SeriesCollection(1) myData = Array(9, 6, 7, 1) ‘ … Read more
Using the autopct keyword As we know that the percentage shown times the sum of all actual values must be the actual value, we can define this as a function and supply this function to plt.pie using the autopct keyword. import matplotlib.pyplot as plt import numpy labels=”Frogs”, ‘Hogs’, ‘Dogs’ sizes = numpy.array([5860, 677, 3200]) colors … Read more