Illustrator Stacked Bar Chart with Negative and Positive Numbers

[ParreLaws]

Is it possible to create a stacked bar chart with both negative and positive like the one below?

[meganchi]

Yes, when you use the chart tool, type a negative sign in front of your number and hit enter.

[ParreLaws]

Thanks, but that does not solve my issue. The issue is some bar have both a negative for the teal part and positive for the lime part. This give me an error message that says "Can't crate the graph. Each stacked column must contain all positive or all negative data."

[Monika Gause]

You can't have a positive lime and a negative teal in one place. That's what the message says. Your example chart will work, but waht you actually want to do, won't.

Put them into two separate charts and stack them. Or use a different app to create the charts and then style them in Illustrator. Simple bar charts should be exported as vector files from Excel.

[Pu Koh]

Frustrating that this can't be done. Not even like it's unreasonable.

[meganchi]

I know it seems frustrating, but that type of chart should probably be generated in something like excel because it requires computing and business tool type of software. Illustrator is a design program and therefore does not have robust charting capability.

The work around is to do as @Monika Gause suggested, or you could draw a bunch of separate rectangles and color them individually to achieve your split chart colors.

[Greg Harbour]

I have no problem holding Adobe accountable for delivering this functionality. Seems like a reasonable and anticipateable requirement of users creating stacked bar graphs. It's just degrees of existing capability, not asking them to write another Excel.

[Anubhav M]

Hello @Greg Harbour,

Thanks for reaching out. At this time, Illustrator does not have this functionality. Would you mind creating a UserVoice for this feature request (https://adobe.ly/3Rk3Pjg) and adding your comments there? Doing this will help prioritize this request, and you will be notified of any updates.

Feel free to reach out if you have more questions or need assistance. We'd be happy to help.

Thanks,
Anubhav

[trann83073661]

Hi there 
i have solution for this 
If you have Ilustrator 2020 or 2019 version you could modify the chart by this 

1) Open illustrator with new file 
Chose Collum graph tools 


and draw a basic graph first 
2) Double click again on the graph tool icon it will appear a pop up window name Graph Type 

3) Then chose Graph Options --> Value Axis --> Tick on the Override Calculated Values 
Now you have the Min and Max Values, you could put negative number at the Min box and Max is positive number 
The Division box is the place you input how much Divisions for the graph 
For ex: like the graph above :
I will put like picture
Min : -15
Max :10
Divisons : 5
Then press OK you will have the result the graph will have both negative and positive units