Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Tons Per Hour & Efficiency (Up Time)
I'm trying to generate a chart with tons per hour on the y-axis and
efficiency on the y-axis as well (opposite the to the first), and the date on the x-axis. So, I guess what I want to do is have the ability to have two y-axis. any help will be appreciated! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Tons Per Hour & Efficiency (Up Time)
First generate the chart with 2 variables (ton/hr and efficiency) with the
date on the X-axis, then once the chart is built, click the one that you want on the right y-axis, right click and select Format Data Series, from there go to the tab Axis and select Secondary axis. Now you have independent scale for each variable, once on the left y-axis and the other in the right y-axis. Hope that help -- Cesar " wrote: I'm trying to generate a chart with tons per hour on the y-axis and efficiency on the y-axis as well (opposite the to the first), and the date on the x-axis. So, I guess what I want to do is have the ability to have two y-axis. any help will be appreciated! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Tons Per Hour & Efficiency (Up Time)
Hi,
You could use a dual Y-axis chart type. (In the wizard 1st step, choose Custom Tyes and Line on 2 axis or Line-Column on 2 axis). Or you could use a 3D chart, but many people do not like these/ -- Thanks, Shane Devenshire " wrote: I'm trying to generate a chart with tons per hour on the y-axis and efficiency on the y-axis as well (opposite the to the first), and the date on the x-axis. So, I guess what I want to do is have the ability to have two y-axis. any help will be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart - Tons Per Hour & Efficiency (Up Time) | Excel Discussion (Misc queries) | |||
"h:mm" format, but 12-hour time, not 24-hour time? | Excel Discussion (Misc queries) | |||
Converting a range of cells from tons to metric tons | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
Convert net tons to long tons in an Excel Spreadsheet. | Excel Worksheet Functions |