Hi, I'm wondering if this is even possible, I tried searching the forum to see if anyone asked about this already.
I'm trying to create a chart in Excel that basically has a y-axis that is a reflection around the x-axis, with the y-axis representing percentages. On the positive y-axis, I wish to have a column, cone or box that basically shows a percentage value (e.g.60%) and along the negative y-axis I wish to show the complimentary percentage value (i.e., in this case, 40%). The x-axis should show four groups of three columns/cones/boxes each.
Does this sound feasible, what other information should I provide? I'm still have problems with providing excel data on the forum, but I can send my excel file to anyone willing to help, it's pretty small.
Thanks so much.
Joe.
I'm trying to create a chart in Excel that basically has a y-axis that is a reflection around the x-axis, with the y-axis representing percentages. On the positive y-axis, I wish to have a column, cone or box that basically shows a percentage value (e.g.60%) and along the negative y-axis I wish to show the complimentary percentage value (i.e., in this case, 40%). The x-axis should show four groups of three columns/cones/boxes each.
Does this sound feasible, what other information should I provide? I'm still have problems with providing excel data on the forum, but I can send my excel file to anyone willing to help, it's pretty small.
Thanks so much.
Joe.