RichardMGreen
Well-known Member
- Joined
- Feb 20, 2006
- Messages
- 2,177
Hi all
I'm trying to sort out a chart that will have between 1 and 28 items on the X-axis.
At the moment, I'm plotting all 28 items (eve if they're blank) and the graphs look a mess.
I've done a bit of research into this, but I didn't understand any of it.
My formulas for producing the graphing data go from J28 to J55 on Sheet "Graphs".
Can someone please give me some idiot-proof instructions on sorting this graph out so it only shows displayed information for 2 Y-Axes and the X-Axis so the graphs automatically sorts itself out?
I'm trying to sort out a chart that will have between 1 and 28 items on the X-axis.
At the moment, I'm plotting all 28 items (eve if they're blank) and the graphs look a mess.
I've done a bit of research into this, but I didn't understand any of it.
My formulas for producing the graphing data go from J28 to J55 on Sheet "Graphs".
Can someone please give me some idiot-proof instructions on sorting this graph out so it only shows displayed information for 2 Y-Axes and the X-Axis so the graphs automatically sorts itself out?