Creating A Chart Showing Magnitude (2 X-Axis)

[shapirja]

Hi,

I am trying to create a chart that shows the magnitude (first X axis) of a weighted average (Y axis) per Unit (second X axis).

It needs to visually show the weighted average over time.

Can you individually stretch each bar on a bar graph to show individual magnitudes?

Thanks for all your help!!!

Jeff

 

[Jon Peltier]

It isn't clear what you want. What are individual magnitudes of a weighted average?

If you want to show weighted average over time, put the time in the first column and the weighted average in the second. If the times are really dates, make a line chart. If the times are in fact times, make an XY chart, and use the option that connects markers with lines.