Is it possible to create a stacked bar chart with both negative and positive like the one below?
Yes, when you use the chart tool, type a negative sign in front of your number and hit enter.
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."
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.
Frustrating that this can't be done. Not even like it's unreasonable.
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.
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
Divisons : 5
Then press OK you will have the result the graph will have both negative and positive units