PDA

View Full Version : Scaling Values in a Chart.



paulked
04-15-2008, 10:20 AM
I have a data series in one sheet which is made up of around 600 values. These values have been logged from a machine tilt angle and range from 150 to 210. The machine tilts from 180 (level) up to a value, back to level, down to a value, back to level and so on. The data in the chart looks like the attached file.

What I would like to do is display the same chart but with the actual tilt angles on (ie level is 0 upper is 30 and lower is -30).

Is there a way to do this?

Many thanks

Paul Ked

mdmackillop
04-15-2008, 11:13 AM
Paul,
Can you post a table of values that will produce your chart

paulked
04-15-2008, 04:54 PM
Hi,

I've attached the workbook without all the "stop people messing" stuff!

Most code is missing, but the raw code and data for the charts are there.

Thanks for any help

Paul Ked

paulked
04-17-2008, 04:55 AM
There is a copy of the full sheet here http://vbaexpress.com/forum/showthread.php?t=19043
if needed :devil2: