![]() Right-click the chart itself and click Select Data., select on of the series to use the secondary axis and define the Horizontal (Category) Labels.įrom the ribbon make the Secondary Axis visible, like so: And inside the Series Options tab choose Secondary Axis. Right-click the series line for each series that should use the secondary pair of axis, select Format Data Series. ![]() Instructions:Ĭreate your basic chart with the required series. ![]() You can have a "primary" and "secondary" axis in some chart types (line, column and bar at least maybe others) - they are in pairs so you can't have a secondary x-axis without a secondary y-axis, but you can make the secondary y-axis identical to the primary version, and then hide it, so it has no effect on the graph.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |