table with negatives values
Hi,
I have the following table with a negative value, i need that the negative value appears in the positive site with different color in the graph, how i can do that?
table-with-negatives.xlsx
I have the following table with a negative value, i need that the negative value appears in the positive site with different color in the graph, how i can do that?
table-with-negatives.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
I need to the negatives values appear like positive with a different color, modifying the graph. I don't want to use formulas because the original table is big and occurs many modifications, any idea?
I need to the negatives values appear like positive with a different color, modifying the graph. I don't want to use formulas because the original table is big and occurs many modifications, any idea?
joyacv2,
If you need to do this then since you want them with positive values..You need to show them positive values and post that then you need to identify them to color them either by code...
How do you want to arrange your data in that case because if you show negative ..In graph it will come on the negative side of the axis only..The enclosed solution which i gave is the most easiest solution which you can implement as well easily..with minor changes...
Saurabh...
If you need to do this then since you want them with positive values..You need to show them positive values and post that then you need to identify them to color them either by code...
How do you want to arrange your data in that case because if you show negative ..In graph it will come on the negative side of the axis only..The enclosed solution which i gave is the most easiest solution which you can implement as well easily..with minor changes...
Saurabh...
ASKER
ok, thanks
Right- Click the chart
Format Data Series / Series Options
Overlapped 100%