Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Points with the same value lie on top of each other - displace, move
This question was asked a few years ago by someone else:
http://groups.google.co.uk/group/mic...35a4916f3440fc Basically, I am using a line chart for a 'wrong' purpose. X axis values are actually categories and data points are not joined by lines. I am doing this to produce a chart such as this: http://conceptwheel.servehttp.com/chart.gif . The answer given in the previous thread suggested faking numbers on a scattergraph to create the effect. But that was in 2004 - I assume there must be, at least by now, a better way to do this! This is actually quite a common graph in scientific literature so someone must have made a plugin or script, surely! Looking forward to hearing from someone, Paul |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Points with the same value lie on top of each other - displace, move
Paul:
You can generate exactly what you want with an XY chart and a dummy axis series. This page gives the basics. There are a number of dummy axis examples on the site. http://processtrends.com/pg_charts_d...xis_series.htm ...Kelly "Paul" wrote in message ups.com... This question was asked a few years ago by someone else: http://groups.google.co.uk/group/mic...35a4916f3440fc Basically, I am using a line chart for a 'wrong' purpose. X axis values are actually categories and data points are not joined by lines. I am doing this to produce a chart such as this: http://conceptwheel.servehttp.com/chart.gif . The answer given in the previous thread suggested faking numbers on a scattergraph to create the effect. But that was in 2004 - I assume there must be, at least by now, a better way to do this! This is actually quite a common graph in scientific literature so someone must have made a plugin or script, surely! Looking forward to hearing from someone, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Several questions about move cursor | Excel Discussion (Misc queries) | |||
Can this be done using an array formula ? | Excel Worksheet Functions | |||
hlookup function | Excel Worksheet Functions | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) |