Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line-Column 2 axes Help
I can't seem to set up a line/column graph and format it correctly. I have
over 10 series of elevation data and corresponding dates from one worksheet, and precipitation data and corresponding dates from another worksheet. I have the the elevation series plotted to the 2nd x axis (date) and the precipitation series plotted to the 1st x asis (date). Precip data on the left y axis and Elevation data on the right y axis. Ideally, what I want is line graphs for the elevation data and bar chart for the precip data. I can either get ALL the data to be line graph data, or one of my elevation series as bar chart. I can't seem to change this regardless of the various chart or formatting options I choose. Anybody have any suggestions? K |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
Column & Line Charts | Charts and Charting in Excel |