View Single Post
  #1   Report Post  
Rochelle B
 
Posts: n/a
Default A mjultiple Line/Data on a single chart

I need to create a chart to show each individual Community $/sft range in
comparison. I can not get excel to create the x axis on a range from 693 sqft
(lowest) to 1346 (highest) and then place the $ tick where it should fall
into the sqft amount for that price. Excel either picks up 1 of the three
sqft ranges (it wont create a range), (or) labels each sqft ft as series
1,2,3,4,5,6,7, etc...My Series are the Community Names, not the sqft amounts.
I can't figure out what I am doing wrong. My boss needs this graph for a
meeting today at a meeting - Please Help

Milano Terrace aka Shadow
Brook $189,900 $245,900 $304,900 $269,900 $400,900
sqft 693 733 1068 915 1221

Bella Terra aka City Place $199,900 $209,900 $299,900 $329,900 $365,950
sqft 736 794 1046 1070 1248

The Plaza aka San
Mateo $214,950 $224,950 $304,950 $314,950 $324,950 $374,950
sqft 773 910 1120 1180 1207 1346