J
Jamie M.
I am frustrated with Excel's limited charting ability. To produce many
effects, you must fragment your data and trick Excel with it, and to my mind
this makes the data table confusing to anyone who might look at it apart
from the creator, and also essentially eliminates the ability to change data
in the table and see the change immediately on the chart.
I understand other software may be used for charting, but I haven't been
able to find anything on Google because apparently the word "charting"
usually refers to the charting of stocks, so all the pages I find refer to
software for stocks only. Even with "-stocks", I get charting software for
astrology, family trees, and other financial applications. The only
general-purpose software I've found other than Excel is DeltaGraph, and it
appears that version 5 of DeltaGraph is terminally buggy (so say users on
the discussion board being maintained by Red Rock Software, the new owners
of DeltaGraph: http://support.redrocksw.com/board/index.php?board=4). All I
really need to make is bar, column, line, and XY charts, but I need more
flexibility with them.
(For example, I need a simpler way to break the Y axis than the very clever
trick on Tushar Mehta's page. I'd like to have minor gridlines on the first
quarter of my chart only. I'd like to make a clustered stacked column chart
with out having to fragment my data as Stephen Bullen does at
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting.)
Sorry to run on. Perhaps I could use Illustrator and draw charts by hand?
Any advice greatly appreciated.
Jamie
effects, you must fragment your data and trick Excel with it, and to my mind
this makes the data table confusing to anyone who might look at it apart
from the creator, and also essentially eliminates the ability to change data
in the table and see the change immediately on the chart.
I understand other software may be used for charting, but I haven't been
able to find anything on Google because apparently the word "charting"
usually refers to the charting of stocks, so all the pages I find refer to
software for stocks only. Even with "-stocks", I get charting software for
astrology, family trees, and other financial applications. The only
general-purpose software I've found other than Excel is DeltaGraph, and it
appears that version 5 of DeltaGraph is terminally buggy (so say users on
the discussion board being maintained by Red Rock Software, the new owners
of DeltaGraph: http://support.redrocksw.com/board/index.php?board=4). All I
really need to make is bar, column, line, and XY charts, but I need more
flexibility with them.
(For example, I need a simpler way to break the Y axis than the very clever
trick on Tushar Mehta's page. I'd like to have minor gridlines on the first
quarter of my chart only. I'd like to make a clustered stacked column chart
with out having to fragment my data as Stephen Bullen does at
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting.)
Sorry to run on. Perhaps I could use Illustrator and draw charts by hand?
Any advice greatly appreciated.
Jamie