Replies: 1 comment
-
I have found the answer, I had to set the VaryColors to false |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi everyone!
I want to ask about how to make a 2D Clustered Column Chart chart in Excelize, here are the details:
From this table:
![Screen Shot 2023-10-25 at 10 41 13](https://private-user-images.githubusercontent.com/36620482/277866382-898a1190-8ec3-4c48-ae54-e4039569c802.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTg3Njg5NDIsIm5iZiI6MTcxODc2ODY0MiwicGF0aCI6Ii8zNjYyMDQ4Mi8yNzc4NjYzODItODk4YTExOTAtOGVjMy00YzQ4LWFlNTQtZTQwMzk1NjljODAyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MTklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjE5VDAzNDQwMlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTk4ZWU0ZGY0OTdhMzhiM2Y0MGIwYjRjODlmNWNkOTkwYTNmNjBhZTAwNjRlOTE5ZDhkM2MxMDAyMGUxZGU0NDQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.57OqedB7mT6y9Hojm1uD5qMza-3rw7xU6rmbmYSsT20)
I want to make a chart like this:
![Screen Shot 2023-10-25 at 10 38 23](https://private-user-images.githubusercontent.com/36620482/277865930-c7167421-dfba-448d-93cf-600fcc02eaf6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTg3Njg5NDIsIm5iZiI6MTcxODc2ODY0MiwicGF0aCI6Ii8zNjYyMDQ4Mi8yNzc4NjU5MzAtYzcxNjc0MjEtZGZiYS00NDhkLTkzY2YtNjAwZmNjMDJlYWY2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MTklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjE5VDAzNDQwMlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTY1Y2JkOTdkMWIwNzY0ODExNDc3OTRiZGE5N2I5YjM2YTEyNjYzNGU1ZWFjYzliYzAwY2FmYmE2YmJhOGExYjImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.CdYoNSidK1HVXwvblTxJXhYL9_gYHBo1dmxpc5qZHVs)
I have tried with this code:
But the code creates a chart like this:
![Screen Shot 2023-10-25 at 10 47 33](https://private-user-images.githubusercontent.com/36620482/277867383-ae085cac-0fc0-4417-b9e8-8f0e0ce82b7f.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTg3Njg5NDIsIm5iZiI6MTcxODc2ODY0MiwicGF0aCI6Ii8zNjYyMDQ4Mi8yNzc4NjczODMtYWUwODVjYWMtMGZjMC00NDE3LWI5ZTgtOGYwZTBjZTgyYjdmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MTklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjE5VDAzNDQwMlomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRjMDM5NzUzZDI2MWVmZjg0ZDkwMzYzNzA2NWZkMzU5NDJiNzA3NmUwMWI5N2IwYzgxMmE5NDBhZjkxZjgzYTcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.8iQ2WN1hNoD1sP9ByD8WKa74lWwk7YE1Ek6n_rLKyh0)
can I create a chart like I want, using Excelize?
I have checked the Excel file directly by comparing the data used between the two tables and the results are the same, I am confused as to why the resulting output is different.
Beta Was this translation helpful? Give feedback.
All reactions