Highlighted

Illustrator Stacked Bar Chart with Negative and Positive Numbers

Community Beginner ,
Apr 18, 2019

Copy link to clipboard

Copied

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

Chart Sample.PNG

Views

742

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Illustrator Stacked Bar Chart with Negative and Positive Numbers

Community Beginner ,
Apr 18, 2019

Copy link to clipboard

Copied

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

Chart Sample.PNG

Views

743

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Advocate ,
Apr 18, 2019

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Apr 18, 2019

Copy link to clipboard

Copied

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."

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Adobe Community Professional ,
Apr 18, 2019

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Contributor ,
Jun 19, 2019

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Advocate ,
Jun 19, 2019

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Sep 08, 2020

Copy link to clipboard

Copied

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 
Screen Shot 2020-09-08 at 6.19.36 PM.png
Screen Shot 2020-09-08 at 6.17.41 PM.png
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 
Screen Shot 2020-09-08 at 6.22.30 PM.png
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
Screen Shot 2020-09-08 at 6.29.09 PM.png

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...