Graph Actual Percent with Suggested Percent

**jaytaylor** · 07-05-2010, 01:27 AM

I have a spreadsheet with suggested List % vs Actual %
What would be the best way to graph this data and how?
Thanks for any help.

**teylyn** · 07-05-2010, 01:57 AM

Hi jaytaylor,

a clustered column chart would be a good approach. Select A1 to C15, then click Insert - Column chart - clustered column chart.

**jaytaylor** · 07-05-2010, 05:06 AM

teylyn,

Thanks for the fast answer. I did that and it works but I need to format it to show the percentages in the right format, preferrably by increments of .10

I attached the example.xlsx update so you could see what I was seeing.

Thanks

**Andy Pope** · 07-05-2010, 05:11 AM

If you format all the cells in the range C2:D15 the axis will display %s

Adjust the Major value if you want to see alternative increments.

**teylyn** · 07-05-2010, 05:13 AM

just change the number format of the Y axis to %.

Set the Major unit of the axis to 0.001 and the max value to 0.12 or thereabouts.

**jaytaylor** · 07-05-2010, 07:09 AM

Thank you all for your support. It works like I expected now.

Graph Actual Percent with Suggested Percent

LinkBack

Thread Tools

Rate This Thread

Display

Graph Actual Percent with Suggested Percent

Re: Graph Actual Percent with Suggested Percent

Re: Graph Actual Percent with Suggested Percent

Re: Graph Actual Percent with Suggested Percent

Re: Graph Actual Percent with Suggested Percent

Re: Graph Actual Percent with Suggested Percent

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions