M
martin0642
Hi all,
Bit of a knotty problem. I have a line graph showing numbers usin
particular drugs, as reported to various agencies, by quarter. Eac
line represents the numbers reporting use of each drug within eac
quarter. (One line for each drug)
All is fine until we throw heroin into the plot. Without it, each lin
is clearly spaced and its fairly easy to read the graph.
The problem with throwing heroin in as well (which we really need t
do) is that the numbers are so high it inflates the scale and all th
other drugs end up squashed down the bottom of the graph.
So...Is there a way in Excel to have the y axis split about halfway u
so we can represent all the drugs without heroin artificially squashin
everything else down?
Hopefully i've explained that well enough!!!
Any clues folks
Bit of a knotty problem. I have a line graph showing numbers usin
particular drugs, as reported to various agencies, by quarter. Eac
line represents the numbers reporting use of each drug within eac
quarter. (One line for each drug)
All is fine until we throw heroin into the plot. Without it, each lin
is clearly spaced and its fairly easy to read the graph.
The problem with throwing heroin in as well (which we really need t
do) is that the numbers are so high it inflates the scale and all th
other drugs end up squashed down the bottom of the graph.
So...Is there a way in Excel to have the y axis split about halfway u
so we can represent all the drugs without heroin artificially squashin
everything else down?
Hopefully i've explained that well enough!!!
Any clues folks