| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 65206 | 2006-01-11 00:43:00 | Excel 2000 help needed | Billy T (70) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 419976 | 2006-01-11 00:43:00 | Hi Team I have created a vertical bar-chart with Y axis values from 0-1000 in 100 unit steps. On the X axis I have 8 different data values shown in the actual bars. There is a statutory maximum value of 500 for the parameter I am recording and I want to apply a coloured horizontal line across the chart to give instant recognition of which values lie above or below that level, or at least format the 500 in bold or colour to mark the stat max. Is it possible to do this? In line graphs I have fudged a similar result by inserting an additional parameter with every entry the same value, but that was a time consuming kludge and won't work for bar charts. Hopefully there is a way to do this for bar charts, and there has to be a better way for line graphs as well, though that isn't an issue at present. I've searched the help files, but I am handicapped by not knowing what to call it! Any assistance would be most welcome. Cheers Billy 8-{) |
Billy T (70) | ||
| 419977 | 2006-01-11 00:49:00 | Can't you define an extra label axis (without any labels, of course) and specify whereabouts it is put? Of course I'd just do something like /oldthick getlinewidth def 0 500 moveto 2 setlinewidth maxX 500 lineto stroke oldthick setlinewidthBut I use PostScript. :cool: |
Graham L (2) | ||
| 419978 | 2006-01-11 00:59:00 | I know there's probably a way of doing this in Excel, but I usually do graph "post-work" in Adobe Photoshop. | kingdragonfly (309) | ||
| 419979 | 2006-01-11 01:04:00 | Could you clarify that a bit more for me please Graham? It sounds similar to what I do with line graphs but the concept of adding an axis is a bit novel for me. I can see that I would want it in the "Value Axis" area but how to get it to extend across the chart and colouring it is more than obscure. :( I have tried setting the axis crossover at 500 but that shifts the axis information up into the middle as well and that gets very messy and illegible. Cheers Billy 8-{) |
Billy T (70) | ||
| 419980 | 2006-01-11 01:14:00 | I haven't used any packaged plotting like Excel very much at all . . . I used to use CGM routines, and CGLE . It's quite common to need two or more sets of points on one graph . They can have different scales for X or Y (or be totally different types of information) . So it's usually possible to have two or more sets of X axis or Y axis labels . If there are just two, they are often placed top and botton, or leftside and right side . But I think it ought to be possible to specify that you want to put a second X axis scale just above the normal one . Or 1/4 of an inch above it . Or halftway up the graph . Or at the 500 Y level . And there's no compulsion to have a scale on that extra X axis . I'm sure you can have different colours for the labels and their axes . Or can you just define a line graph overlaid on the same frame, which is just a horizontal line? |
Graham L (2) | ||
| 419981 | 2006-01-11 01:29:00 | Have a look at this Tip Sheet (tfserver.otago.ac.nz/SCS/TipSheets/Tip Sheet brochures/04 Tip Sheet Excel.pdf) (the second page ). Seems to be something like ... "Chart Wizard/Custom Types/Two Axis ". The exampkle is for Y axis, but I'm sure it will work for X too. |
Graham L (2) | ||
| 419982 | 2006-01-11 01:52:00 | Hmmm . . . . . . Well, line-column does what I want after a fashion . It inserts the statutory limit as a horizontal line, but then it takes the fourth bar data and makes that into a line as well, so I get a 3-2 combination bar/line . I can convert it back to a bar, but it superimposes itself over the first two bars . Dammit! :mad: Any more ideas? I can't imagine that users are restricted to a 3-2 data split, so there must be a way to order the Excel data file so thet the chart picks it up correctly . Thanks for the help so far, I'm off back to the help files . :( Cheers Billy 8-{) |
Billy T (70) | ||
| 419983 | 2006-01-11 02:03:00 | You shouldn't have to be doing anything to the actual data bars; just adding an axis line. | Graham L (2) | ||
| 419984 | 2006-01-11 02:25:00 | It didn't seem to give an option just to add an axis line Graham, and I needed to add the "500" data to the original spreadsheet anyway . I added that then used the Custom Chart>Line Column option which took me 80% of the way to where I wanted to be . Unfortunately it achieved that by subtracting 25% of my original chart . :confused: I can't find a damned thing in the help files either, and to cap it all, I accidentally closed without saving (instead of minimising) and lost the original data as well . :eek: That's no problem to recover though, it was copied and pasted from other spreadsheets and there was very little of it . Cheers Billy <8-{( |
Billy T (70) | ||
| 419985 | 2006-01-11 04:26:00 | Didn't the "Two Axis" give you another axis line? This is why I like doing it myself . Then things which are wrong are my fault . |
Graham L (2) | ||
| 1 | |||||