charting day and month

  • Thread starter Thread starter jconrad77
  • Start date Start date
J

jconrad77

I have a table of individual days of the year, value "A" and cummulativ
value of A.

I would like to plot the cummulative data as a line chart, and on th
same graph show the monthly sum of A for each month.

I have tried to do this by having the monthly sums displayed on th
last day of each month - but when this is plotted it will only dipla
as a really skinny line (as if to acccomodate the other days which hav
no values). - also this is 'cheating' really, there must be a bette
way.

any ideas appreciated,

thanks for your help,

J
 
If you want regular looking bars, you have to change the time scale axis
to a plain old category axis. Right click on the chart, select Options,
click on the Axes tab, and check Category for Category (X) Axis. Your
data points will be equally spaced now, not spaced according to elapsed
number of days, but the columns will not be skinny little twigs far apart.

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