Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
scatter and line combined
Is it possible to create a chart that combines scatter and line elements?
I am comparing actual salaries with market standards. I can chart these separately. I've got a line chart showing the 25th, Median and 75th quartile salaries for the industry at 1, 2, 3, etc. years of experience. I can also create a nice scatter graph that plots time on the X- and salary on the Y-axis. The trouble comes when I want to combine the two. The source data for the line chart has three columns of data (salaries under each category), plus a fourth for data series labels (# of years, whole numbers). While the source data for the scatter is just two columns: time (fractions of years) and salary. Is there a common solution for this objective? If so, what topics in Excel help should I read up on? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
combined line-column excel chart | Charts and Charting in Excel | |||
combined scatter plot and line data | Excel Discussion (Misc queries) | |||
Combined bar and line chart (two Y axis) how to make excel know which data goes where | Charts and Charting in Excel | |||
Combined line/stacked column chart | Charts and Charting in Excel |