Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
June 18, 2006, 1:02 pm
rate this thread
I am struggling to produce INCREDIBLY simple charts with Excel (v2003).
I am trying to *speed up* (i.e. reduce the number of clicks) to produce
a new chart.
To save time, I dont want to have to *do* anything to the source data
when it arrives.
This is partly because we are needing to paste in live data several
time a day (i.e. data that is added to/is changed as the day
The data arrives as .CSV and it is one row per transaction e.g. like
I have imported each .CSV file into Excel, with one day per worksheet.
And I have created a basic Line chart.
I have then added the time column (i.e. the second column - col "B") of
each datasheet to be a Data Series for the chart.
I am trying to chart time vs. number of transactions (within a 24 hour
period). And I also need to see more than one day's performance on the
I would like time to go along the X-axis but Excel puts it on the Y
I am also struggling to get the X-axis to be along the BOTTOM, rather
then the top
of the chart!
Plus I cant get the X-axis to start at zero - it seems to insist on
starting at 1 (not 0)!!
I am on the point of dispair - I dont need anything complex, 3D etc -
but I just cant
get Excel to do the basics.
- Any thoughts?
- Are there any Excel charting plug-ins to make life easier?
- Or is there something good and cheap (i.e. less than $25.00) that is
intuitive that comes highly recommended instead of Excel?!
- » How to make sure an iFrame is referenced before pasting html into it (ping Martin Honen)
- — Previous thread in » Webmaster Forum