Home |
Search |
Today's Posts |
#1
|
|||
|
|||
second Y axis
The help screen says that it can be done (if you understand the cryptic
notes). I have a large chart that needs to have a separate set of line graphs overlayed from the right hand Y axis with different scaling. The help screen says something about a "format menu" which I have no idea what it is. I think it means to select the data on the excel spreadsheet then go to the menu. Can anyone help this novice do a job? |
#2
|
|||
|
|||
I guess this is what I get for using Excel once each year. My chart is a
chart of ten costs on a area chart over time. I need to incorporate another value which is totally different to compare to the costs series. I don't want to go back and start over and I don't follow the cryptic explanations of people who know what they are doing. I am a novice getting frustrated trying to do something that should be simple. If someone can point me to a MVP paper or some detail explanation of placing two line graphs over ten cost area graphs, I would appreciate it. "jay" wrote: The help screen says that it can be done (if you understand the cryptic notes). I have a large chart that needs to have a separate set of line graphs overlayed from the right hand Y axis with different scaling. The help screen says something about a "format menu" which I have no idea what it is. I think it means to select the data on the excel spreadsheet then go to the menu. Can anyone help this novice do a job? |
#3
|
|||
|
|||
Input your data.
Right-click the series you need to have on a different axis and choose Format Data Series. On the Axis tab, choose Secondary Axis. Then adjust the Axis scale as necessary by right-clicking it and choosing Format Axis. Or double-click it. -- Echo [MS PPT MVP] http://www.echosvoice.com "jay" wrote in message ... I guess this is what I get for using Excel once each year. My chart is a chart of ten costs on a area chart over time. I need to incorporate another value which is totally different to compare to the costs series. I don't want to go back and start over and I don't follow the cryptic explanations of people who know what they are doing. I am a novice getting frustrated trying to do something that should be simple. If someone can point me to a MVP paper or some detail explanation of placing two line graphs over ten cost area graphs, I would appreciate it. "jay" wrote: The help screen says that it can be done (if you understand the cryptic notes). I have a large chart that needs to have a separate set of line graphs overlayed from the right hand Y axis with different scaling. The help screen says something about a "format menu" which I have no idea what it is. I think it means to select the data on the excel spreadsheet then go to the menu. Can anyone help this novice do a job? |
#4
|
|||
|
|||
In what screen or window do I right click on the series? In the spradsheet?
In the source data window? If in the spreadsheet do I need to name the series first? Do I need to select the serries entries before right clicking? "Echo S" wrote: Input your data. Right-click the series you need to have on a different axis and choose Format Data Series. On the Axis tab, choose Secondary Axis. Then adjust the Axis scale as necessary by right-clicking it and choosing Format Axis. Or double-click it. -- Echo [MS PPT MVP] http://www.echosvoice.com "jay" wrote in message ... I guess this is what I get for using Excel once each year. My chart is a chart of ten costs on a area chart over time. I need to incorporate another value which is totally different to compare to the costs series. I don't want to go back and start over and I don't follow the cryptic explanations of people who know what they are doing. I am a novice getting frustrated trying to do something that should be simple. If someone can point me to a MVP paper or some detail explanation of placing two line graphs over ten cost area graphs, I would appreciate it. "jay" wrote: The help screen says that it can be done (if you understand the cryptic notes). I have a large chart that needs to have a separate set of line graphs overlayed from the right hand Y axis with different scaling. The help screen says something about a "format menu" which I have no idea what it is. I think it means to select the data on the excel spreadsheet then go to the menu. Can anyone help this novice do a job? |
#5
|
|||
|
|||
Select it on the chart itself. I should have said, "Input all your data and
create a column chart. Then right-click on the chart the series you need and choose Format Data Series...." -- Echo [MS PPT MVP] http://www.echosvoice.com "jay" wrote in message ... In what screen or window do I right click on the series? In the spradsheet? In the source data window? If in the spreadsheet do I need to name the series first? Do I need to select the serries entries before right clicking? "Echo S" wrote: Input your data. Right-click the series you need to have on a different axis and choose Format Data Series. On the Axis tab, choose Secondary Axis. Then adjust the Axis scale as necessary by right-clicking it and choosing Format Axis. Or double-click it. -- Echo [MS PPT MVP] http://www.echosvoice.com "jay" wrote in message ... I guess this is what I get for using Excel once each year. My chart is a chart of ten costs on a area chart over time. I need to incorporate another value which is totally different to compare to the costs series. I don't want to go back and start over and I don't follow the cryptic explanations of people who know what they are doing. I am a novice getting frustrated trying to do something that should be simple. If someone can point me to a MVP paper or some detail explanation of placing two line graphs over ten cost area graphs, I would appreciate it. "jay" wrote: The help screen says that it can be done (if you understand the cryptic notes). I have a large chart that needs to have a separate set of line graphs overlayed from the right hand Y axis with different scaling. The help screen says something about a "format menu" which I have no idea what it is. I think it means to select the data on the excel spreadsheet then go to the menu. Can anyone help this novice do a job? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |