inverting data for a graph
Well I have two series that graphed, so inverting the axis inverts both
series. I only want one series inverted is this possible?
"Ryan Poth" wrote:
Click on a chart axis, then Format-Selected Axis...
Under the "Scale" tab, tick "Values in reverse order"
HTH,
Ryan
"Chris" wrote:
I looked through all the chart options, where do you see it?
"Marcelo" wrote:
Hi Chris, you could switch this in chart options
HTH
Regards from Brazil
Marcelo
"Chris" escreveu:
Is there a way I could invert a series on a graph? Lets say my data points
are 3,9,2,4,7, but I really want graphed 7,4,2,9,3. Is there a way I could
just switch this in chart options? Here's the complicated part, a simple
solution would be to just invert the numbers in the worksheet using the index
function. However, I'm trying to record a macro and it seems impossible to do
if I use the index function because for different groups of data I'm not sure
what my last cell number will be. Any help?
|