Creating Chart of Percentage complete for task

**GAC1234** · 08-23-2012, 02:39 PM

working in Excel 2010. I have a column A which contains tasks to be performed and column B which shows percentage completion of the task. i selected the 2 columns and attempted to set up a bar graph, but the graph only shows series 1 at 100% no matter what value i have in column B for percentage complete. There is also a series formula attached to the bar that i did not expect. Thought this would be simple task, but excel is trying to do a calculation i did not expect.

**jeffreybrown** · 08-23-2012, 03:48 PM

Maybe a good idea to attach what you are having trouble with. How does it differ from the attached example?

**GAC1234** · 08-23-2012, 03:57 PM

thanks for the reply. I was selecting the wrong type of bar. I had selected the 100% stacked bar. I'm a novice in Excel and didn't know. My issue is resolved.