J
jago25_98
I have to create a graph that has daily data overlaid by monthly data.
Ideally the monthly data would be a bar graph with the daily data as
line graph over top.
'Here's a pic to explain what I mean
(http://apple.termisoc.org/~j/files/excel_nightmare.JPG) (96kb)
I also had the problem that the monthly data was in a differen
arrangement - the date traversing the columns with the daily data wen
vertically.
- To fix it I used the Edit -> Special paste -> transpose option an
then laboriously cut and pasted the resulting arrangement to one bi
column. Wish I knew a better way.
I have seen a charting guide for this:
'on peltiertech.com
(http://peltiertech.com/Excel/Charts/ComboCharts.html#ComboCht) , but
don't have the 'chart
(http://peltiertech.com/Excel/Charts/ComboChart1.html) menu it says t
use (I'm using XP, have a copy of 97/2k as well at home).
I tried messing with the data source for the chart but it doesn't com
out as it says in the guide.
Any ideas? - in particular other methods that I can try, such as:
- rearranaging the data so it can be compared side by side
- averaging each of the daily values into a monthly value to compar
with the monthly values I already have
TIA for any suggestions, or even just *some words I can use to help m
search for help*
Ideally the monthly data would be a bar graph with the daily data as
line graph over top.
'Here's a pic to explain what I mean
(http://apple.termisoc.org/~j/files/excel_nightmare.JPG) (96kb)
I also had the problem that the monthly data was in a differen
arrangement - the date traversing the columns with the daily data wen
vertically.
- To fix it I used the Edit -> Special paste -> transpose option an
then laboriously cut and pasted the resulting arrangement to one bi
column. Wish I knew a better way.
I have seen a charting guide for this:
'on peltiertech.com
(http://peltiertech.com/Excel/Charts/ComboCharts.html#ComboCht) , but
don't have the 'chart
(http://peltiertech.com/Excel/Charts/ComboChart1.html) menu it says t
use (I'm using XP, have a copy of 97/2k as well at home).
I tried messing with the data source for the chart but it doesn't com
out as it says in the guide.
Any ideas? - in particular other methods that I can try, such as:
- rearranaging the data so it can be compared side by side
- averaging each of the daily values into a monthly value to compar
with the monthly values I already have
TIA for any suggestions, or even just *some words I can use to help m
search for help*