Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Just wondering if excel can cope with this?
I'd sooner continue my project in excel than learn another program if possible! I need to produce a graphical representaion of the attached jpg. Perhaps a chart?? (sorry for my leaky pen but hopefully you'll get the idea!) Let me explain. the start point is a variable on a scale 0-100 which the sheet knows. say A B or C A=30 B=45 C=36 The subsequent lines change the start point number ie (using the letters down the right hand side) E = +8 D = +6 C = +2 B = -11 A = -6 The chart needs the slanting lines (repesenting 200,500 etc) or some other indication so that a manual check can be made of the computer caluculation. (The 200,500 lines can be calculated as numbers on the same 0-100 scale) The sheet has elsewhere calculated these numbers and produced a result. Its the graphical representation of whats going on that I'm after. Can it cope, and does anyone have any pointers???? cheers Nobby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you drop the line in a line graph? | Charts and Charting in Excel | |||
Vertical line isn't vertical! | Charts and Charting in Excel | |||
Add a line | New Users to Excel | |||
Markers only appearing on comparison line graph | Charts and Charting in Excel | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel |