Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have a table that has many rows w

Status
Not open for further replies.
Do you mean something like this?

PieChart_uhvdkx.png


If so, select cells B1-C9, Insert - Charts - select your Pie chart

Unless you mean something else by "create a pie chart with this column [non-calculated percentage] as an axis."

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
What story do you want to tell?

D48A84FA-14EB-4E5B-9209-6DA60578A53E_xdurjv.jpg



Here's your workbook...

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!
 
 https://files.engineering.com/getfile.aspx?folder=83ef7a7a-ac8a-4edb-bf00-a366d20ae8be&file=Tek_tips_file.xlsx
Completions are independent and do not sum up to 100%; pie chart naturally shows shares of items in total.
I would rather use clustered bar with multicolumn data axis, here's the default result:
TT_chart_td37i0.png

Excel set Project ID text vertically I couldn't find any setting to change this.

combo
 
Just what I am looking for combo! Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top