How do I add y-axis labeling on the right side of chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to add an axis with same values on the right side of the chart.
 
You'll need to have at least two series in order to enter a secondary axis.
On one of the series, change the Axis to Secondary axis.
 
How can I force the y-axis at the bottom of my chart to appear for all 12
months when I only have Jan, Feb and March figures to put in the first three
months. I don't want any "0"s for blank cells on the page either. Just the
12 months at the bottom and then each month's data as it is available.

Miss Gayle
 
Use this as the source data for your chart:

Data
Jan 15
Feb 17
Mar 18
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Make sure the cells with no values are really blank. The line or columns will stop
at March, but the axis will cover the entire year.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Information on both sides of a chart 1
Swap Y-Axis numbers 3
Duplicate Axis Labels 1
Using the full width of an Excel chart with two Y-axes 2
how to switch the primary and secondary Y axis to opposite chart s 2
Position vertical axis 5
Data labels along below x axis when y axis has negative values 1

Back
Top