View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jaymee Jaymee is offline
external usenet poster
 
Posts: 4
Default data in the chart is wrong

The information i wan tto put in to a chart is;

Contractor Actual Budget
Badger $22,661.10 $143,437.56
Big Eagle $18,325.76 $286,875.00
Ceda $574,256.15 $1,577,812.56
Eveready $173,563.39 $860,625.00
Flint $1,293,965.31 $1,333,333.33
LaPairie $36,350.00 $16,666.66
Northern $113,400.00 $208,333.33

However I want the chart on the y axis to say the percent of the budget that
the actual is. When I do this weither it be a stacked line chart or a stacked
cloumn chart, the percentages are always wrong. I am wondering why the
percentages are wrong. Is there anything I can do to fix this. Please if you
can email me at
I can send you what I am getting if that will help. I really need your help
this is for a report I have due friday!

Thank you!
"Jon Peltier" wrote:

What kind of chart is it? If it's a line chart, did you accidentally select
the stacked line type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______


"Jaymee" wrote in message
...
Hello,
I am creating a chart - Actual vs Budget, a simple chart, however when I
do
teh chart the % is wrong inthe data seris but not for all just the last 3
of
them. The information in the table is correct but not representing it in
the
chart correct. Does anyone know how I can fix this?