Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Fixed Median Value
Hi Folks - I have a chart based on the following data:
State Salary RI 35000 CT 42000 NH 39000 VT 36000 ME 37000 The average salary for all states is 37800. I'd like to chart this data with the states on the x-axis and the salary amount on the y-axis. Here's the catch .. I'd like to chart the average state salary as a fixed horizontal line on the y-axis. Do-able? Thanks, Michael |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Fixed Median Value
Hi,
Use the column next to salary to store the average figure for each State. The simply add an extra data series to the chart and plot as a line. This page contains examples and links to other sites. http://www.andypope.info/charts/averageline.htm Cheers Andy Michael wrote: Hi Folks - I have a chart based on the following data: State Salary RI 35000 CT 42000 NH 39000 VT 36000 ME 37000 The average salary for all states is 37800. I'd like to chart this data with the states on the x-axis and the salary amount on the y-axis. Here's the catch .. I'd like to chart the average state salary as a fixed horizontal line on the y-axis. Do-able? Thanks, Michael -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Fixed Median Value
Andy - I like the simplicity of your method. However, is there a way to
stretch the average line for the full width of the plot area? Michael "Andy Pope" wrote in message ... Hi, Use the column next to salary to store the average figure for each State. The simply add an extra data series to the chart and plot as a line. This page contains examples and links to other sites. http://www.andypope.info/charts/averageline.htm Cheers Andy Michael wrote: Hi Folks - I have a chart based on the following data: State Salary RI 35000 CT 42000 NH 39000 VT 36000 ME 37000 The average salary for all states is 37800. I'd like to chart this data with the states on the x-axis and the salary amount on the y-axis. Here's the catch .. I'd like to chart the average state salary as a fixed horizontal line on the y-axis. Do-able? Thanks, Michael -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart - Fixed Median Value
Hi Michael,
Move the line to the secondary axis. Format the secondary x axis to not cross between categories. To be found at the bottom of the step by step sheet in the download file. Cheers Andy Michael wrote: Andy - I like the simplicity of your method. However, is there a way to stretch the average line for the full width of the plot area? Michael "Andy Pope" wrote in message ... Hi, Use the column next to salary to store the average figure for each State. The simply add an extra data series to the chart and plot as a line. This page contains examples and links to other sites. http://www.andypope.info/charts/averageline.htm Cheers Andy Michael wrote: Hi Folks - I have a chart based on the following data: State Salary RI 35000 CT 42000 NH 39000 VT 36000 ME 37000 The average salary for all states is 37800. I'd like to chart this data with the states on the x-axis and the salary amount on the y-axis. Here's the catch .. I'd like to chart the average state salary as a fixed horizontal line on the y-axis. Do-able? Thanks, Michael -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make fixed format of chart everytime when publish it? | Charts and Charting in Excel | |||
how do i enlarge a pie chart by a fixed percentage? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |