Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
(Very sorry for the double-post to two NG - I forgot about this NG
until after I posted to the other!) I'm trying to re-create a chart I had in XL2003, but in XL2007 the dialog boxes have changed just a bit and I'm lost! I have four trailers that accumulate miles, and I need to chart the number of failures for tires and shocks on both the left and right side of each trailer. So I have named ranges: Miles_A, _B, _C, and _D, LTires_A etc, RTires_A etc, LShocks_A etc and RShocks_A etc. I want Miles across the bottom, and the number of failures per item on the vertical axis. Insert Chart Line Stacked with Markers Select Data Sheet1!LTires_A and from there I am lost!! I can't get the horizontal axis to format because I can't find the options to set the Min, Max, and Interval. I can't make XL2007 understand that I want the miles for all shown across the bottom. I miss the old Chart Wizard where I could define the X and the Y for each data series in one swoop!! How can I make this happen in XL2007? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting in XL2007 | Excel Worksheet Functions | |||
XL2007 Pivot Charts: Path to data in another workbook keeps chang | Charts and Charting in Excel | |||
Max row Height in XL2007 | Excel Discussion (Misc queries) | |||
pivot table primer course | Excel Discussion (Misc queries) | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel |