Creating A Chart Showing Magnitude (2 X-Axis)

shapirja

New Member
Joined
Feb 19, 2009
Messages
6
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,879
Office Version
365
Platform
Windows, MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,551
Messages
5,487,522
Members
407,604
Latest member
sama9000

This Week's Hot Topics

Top