## Different units on same axis in diagram (for example Nm and Lbin on X and MPa and PSI on Y)

MS EXCEL

### Next

• 1. Draw Objects in Charts
I have a Workbook where I enter my Blood Pressure on a daily basis and plot it on an X-Y chart over time. The chart automatically expands the X-axis as new data is entered. I recently changed medication and placed a draw object (vertical line with a caption) at the appropriate date. The problem is that as the X-axis expands and the time between tick marks contracts, the draw object stays at the same position and I have to move it to the correct date tick mark. As the marks become more compressed, it has become difficult to move the object to the exact date. Is there any way to lock a draw object to a specific data point so it remains at the same relative position? Thanks for any help. Mike Hogan
• 2. View Header/Footer in Charts
I added a footer to my chart, but it only displays when I print it or in Page Setup. Is there a way to view it in normal view?
• 3. How do you make a combination chart with 2 axis.
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I put both on same chart?
• 4. How do I change spacing between stackable bar graphs?
Trying to group stackable bars by threes in a six bar graph. Is it possible to make space between first group tighter and a larger space in between before the next tight group of three?

### Re: Different units on same axis in diagram (for example Nm and Lbin on X and MPa and PSI on Y)

Rocky -

Make your chart with just primary axes. Then use this technique to add
the upper and right side axes, based on the conversion between units.

http://www.**--****.com/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://www.**--****.com/
_______

Different units on same axis in diagram (for example Nm and Lbin on X and MPa and PSI on Y)

I would like both of the axis to have the same distance between thei
units. I manage to make it so that both axis increase by 1 by eac
tick, but the physical distance between each tick is not the same o
both axis. The x-axis might have 2cm between each tick, while th
y-axis has 3cm. This creates a false impression of what the grap
actually looks like. I know I can drag the window sideways or up an
down to change this, but that would only be approximate. Anyone