84128

Secondary Axis in axlsx charts

Question:

I am working on the xlsx report generation, and for that I am using axlsx gem. I looking for the option to show secondary <strong>Y-axis</strong> (for 2nd series in charts) in line and bar charts. Is there any way to do so?

Thanks in advance.

Answer1:

I'm not well versed in axlsx much less charting in general, but from what I've read on the documentation there are thee possible 'axes' to choose from. valAxis, catAxis and serAxis. If I'm to assume you want depth to your chart, use serAxis.

<a href="http://rubydoc.info/github/randym/axlsx/Axlsx/SerAxis" rel="nofollow">http://rubydoc.info/github/randym/axlsx/Axlsx/SerAxis</a>

Recommend

  • MP Android Chart-How to fix the number of X-Axis values in the Line Chart?
  • When is invoke required on GUI objects?
  • Silverlight Toolkit chart: Multiple series with bar and line
  • Trouble deciphering function parameters: pointer and pointer to pointer
  • How do I access request metadata for a java grpc service I am defining?
  • Nunit Tests order of Execution
  • Swift: Validate Username Input
  • Add chart on phpoffice/phpword
  • Java graph library [duplicate]
  • Pie-in-pie (Donut) charts
  • How to increase the python speed over loops?
  • Cannot read property 'addEvent' of undefined
  • jquery pie chart with drilldown/clickable pie parts
  • Keep same scale in different graphs ggplot2
  • Adding new column to DataFrame with values dependent on index ref
  • Safari PHP form submission -file upload hangs
  • JFreechart X and Y axis scaling
  • Scala using regex with or syntax in match case statement
  • Convert two columns Pandas data frame to dictionary of list with first column as keys
  • AWS-SES: Handling Bounces for Invalid ISPs
  • C# List of Panels
  • Breaking out column by groups in Pandas
  • How to Cache Real-time Data?
  • Asynchronous UI Testing in Xcode With Swift
  • PHPUnit_Framework_TestCase class is not available. Fix… - Makegood , Eclipse
  • Using $this when not in object context
  • How do I fake an specific browser client when using Java's Net library?
  • Align navbar back button on right side
  • How reduce the height of an mschart by breaking up the y-axis
  • Window Size for Mac application
  • How to extract text from Word files using C#?
  • Perl system calls when running as another user using sudo
  • How can I use Kendo UI with Razor?
  • ActionScript 2 vs ActionScript 3 performance
  • R: gsub and capture
  • VB.net deserialize, JSON Conversion from type 'Dictionary(Of String,Object)' to type '
  • Benchmarking RAM performance - UWP and C#
  • What are the advantages and disadvantages of reading an entire file into a single String as opposed
  • Net Present Value in Excel for Grouped Recurring CF
  • How to push additional view controllers onto NavigationController but keep the TabBar?