{"action":"created","issue":{"url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/154","labels_url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/154/labels{/name}","comments_url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/154/comments","events_url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/154/events","html_url":"https://github.com/jmcnamara/excel-writer-xlsx/issues/154","id":125406868,"number":154,"title":"Secondary axis missing bold font for combined chart","user":{"login":"rdboisvert","id":2737839,"avatar_url":"https://avatars.githubusercontent.com/u/2737839?v=3","gravatar_id":"","url":"https://api.github.com/users/rdboisvert","html_url":"https://github.com/rdboisvert","followers_url":"https://api.github.com/users/rdboisvert/followers","following_url":"https://api.github.com/users/rdboisvert/following{/other_user}","gists_url":"https://api.github.com/users/rdboisvert/gists{/gist_id}","starred_url":"https://api.github.com/users/rdboisvert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdboisvert/subscriptions","organizations_url":"https://api.github.com/users/rdboisvert/orgs","repos_url":"https://api.github.com/users/rdboisvert/repos","events_url":"https://api.github.com/users/rdboisvert/events{/privacy}","received_events_url":"https://api.github.com/users/rdboisvert/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/labels/question","name":"question","color":"d7e102"}],"state":"open","locked":false,"assignee":{"login":"jmcnamara","id":94267,"avatar_url":"https://avatars.githubusercontent.com/u/94267?v=3","gravatar_id":"","url":"https://api.github.com/users/jmcnamara","html_url":"https://github.com/jmcnamara","followers_url":"https://api.github.com/users/jmcnamara/followers","following_url":"https://api.github.com/users/jmcnamara/following{/other_user}","gists_url":"https://api.github.com/users/jmcnamara/gists{/gist_id}","starred_url":"https://api.github.com/users/jmcnamara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jmcnamara/subscriptions","organizations_url":"https://api.github.com/users/jmcnamara/orgs","repos_url":"https://api.github.com/users/jmcnamara/repos","events_url":"https://api.github.com/users/jmcnamara/events{/privacy}","received_events_url":"https://api.github.com/users/jmcnamara/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-01-07T14:43:35Z","updated_at":"2016-01-07T15:32:58Z","closed_at":null,"body":"I found a bug related to the secondary Y axis and combined charts.  If I use the example of the \"Combine chart - secondary Y axis\" provided with the Chart documentation (http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.86/lib/Excel/Writer/XLSX/Chart.pm#Combined_Charts) and change the `set_y_axis ()` and `set_y2_axis ()` functions to include a bold font, then only the primary Y axis is bold. This problem does not occur if not using a combined chart.\r\n\r\n    $column_chart->set_y_axis( name => 'Sample length (mm)', num_font => {bold => 1} );\r\n    $column_chart->set_y2_axis( name => 'Target length (mm)', num_font => {bold => 1} );"},"comment":{"url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/comments/169696564","html_url":"https://github.com/jmcnamara/excel-writer-xlsx/issues/154#issuecomment-169696564","issue_url":"https://api.github.com/repos/jmcnamara/excel-writer-xlsx/issues/154","id":169696564,"user":{"login":"rdboisvert","id":2737839,"avatar_url":"https://avatars.githubusercontent.com/u/2737839?v=3","gravatar_id":"","url":"https://api.github.com/users/rdboisvert","html_url":"https://github.com/rdboisvert","followers_url":"https://api.github.com/users/rdboisvert/followers","following_url":"https://api.github.com/users/rdboisvert/following{/other_user}","gists_url":"https://api.github.com/users/rdboisvert/gists{/gist_id}","starred_url":"https://api.github.com/users/rdboisvert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rdboisvert/subscriptions","organizations_url":"https://api.github.com/users/rdboisvert/orgs","repos_url":"https://api.github.com/users/rdboisvert/repos","events_url":"https://api.github.com/users/rdboisvert/events{/privacy}","received_events_url":"https://api.github.com/users/rdboisvert/received_events","type":"User","site_admin":false},"created_at":"2016-01-07T15:32:58Z","updated_at":"2016-01-07T15:32:58Z","body":"Using your example from (http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.86/lib/Excel/Writer/XLSX/Chart.pm#Combined_Charts) I made the adjustments in **bold**.\r\n\r\n    use strict;\r\n    use warnings;\r\n    use Excel::Writer::XLSX;\r\n\r\n    my $workbook  = Excel::Writer::XLSX->new( 'chart_combined.xlsx' );\r\n    my $worksheet = $workbook->add_worksheet();\r\n    my $bold      = $workbook->add_format( bold => 1 );\r\n\r\n    # Add the worksheet data that the charts will refer to.\r\n    my $headings = [ 'Number', 'Batch 1', 'Batch 2' ];\r\n    my $data = [\r\n        [ 2,  3,  4,  5,  6,  7 ],\r\n        [ 10, 40, 50, 20, 10, 50 ],\r\n        [ 30, 60, 70, 50, 40, 30 ],\r\n\r\n    ];\r\n\r\n    $worksheet->write( 'A1', $headings, $bold );\r\n    $worksheet->write( 'A2', $data );\r\n\r\n    #\r\n    # In the first example we will create a combined column and line chart.\r\n    # They will share the same X and Y axes.\r\n    #\r\n\r\n    # Create a new column chart. This will use this as the primary chart.\r\n    my $column_chart = $workbook->add_chart( type => 'column', embedded => 1 );\r\n\r\n    # Configure the data series for the primary chart.\r\n    $column_chart->add_series(\r\n        name       => '=Sheet1!$B$1',\r\n        categories => '=Sheet1!$A$2:$A$7',\r\n        values     => '=Sheet1!$B$2:$B$7',\r\n    );\r\n\r\n    # Create a new column chart. This will use this as the secondary chart.\r\n    my $line_chart = $workbook->add_chart( type => 'line', embedded => 1 );\r\n\r\n    # Configure the data series for the secondary chart.\r\n    $line_chart->add_series(\r\n        name       => '=Sheet1!$C$1',\r\n        categories => '=Sheet1!$A$2:$A$7',\r\n        values     => '=Sheet1!$C$2:$C$7',\r\n        y2_axis    => 1,\r\n    );\r\n\r\n    # Combine the charts.\r\n    $column_chart->combine( $line_chart );\r\n\r\n    # Add a chart title and some axis labels. Note, this is done via the\r\n    # primary chart.\r\n    $column_chart->set_title( name => 'Combined chart - same Y axis' );\r\n    $column_chart->set_x_axis( name => 'Test number' );\r\n$column_chart->set_y_axis( name => 'Sample length (mm)'**, num_font => {bold => 1}** );\r\n$column_chart->set_y2_axis( name => 'Target length (mm)'**, num_font => {bold => 1}** );\r\n\r\n    # Insert the chart into the worksheet\r\n    $worksheet->insert_chart( 'E2', $column_chart );"}}