Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add y-axis labeling on the right side of chart?
I'd like to add an axis with same values on the right side of the chart.
|
#2
|
|||
|
|||
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. "DavidNHFCU" wrote in message ... I'd like to add an axis with same values on the right side of the chart. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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/ _______ MissGayle wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open two excel windows side by side | Excel Discussion (Misc queries) | |||
xl Headers and Footers always use 3/4 inch side margins??? | New Users to Excel | |||
How do I get my y axis on the left hand side of my chart? | Charts and Charting in Excel | |||
y axis on wrong side | Charts and Charting in Excel | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel |