• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 32
  • Last Modified:

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
0
joyacv2
Asked:
joyacv2
  • 2
  • 2
1 Solution
 
Saurabh Singh TeotiaCommented:
You can do something like this to do what you are looking for...

Saurabh...
table-with-negatives.xlsx
0
 
Rgonzo1971Commented:
to have a regular distance  between columns


Right- Click the chart
Format Data Series / Series Options
Overlapped 100%
0
 
joyacv2Author Commented:
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?
0
 
Saurabh Singh TeotiaCommented:
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...
0
 
joyacv2Author Commented:
ok, thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now