Weekly scale on Y axis

  • Thread starter Thread starter JFAIRBUS
  • Start date Start date
J

JFAIRBUS

Hi!

I'm trying to create a chart that includes a weekly scale on both X & Y
axis.

The format required is as follow: YYwkWW - i.e. 06wk52.

My issue is that after 06wk52, the 07wk01 corresponding value is shown
on level 01 of the y axis (cells are formatted to respond to format
requirements), or there is a gap of 48 between 06wk52 and 07wk01 if a
calculation is applied.

Anyone seen this before???

Cheers for your help!!!

JF
 
YYwkWW only gives me 06wkWW or 07wkWW. The only way to get 06wk52 or 07wk01
is to generate strings, which have no numerical value, and cannot be plotted
along a value axis. I would suggest keeping the data as dates, and construct
X and Y axes using the technique described here:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Chart - Secondary Y-axis with different values/scale 2
Formatting 'X' Axis -- 2 fundamental differences 7
Logarithmic Scale for the X-Axis 1
Make Y-axis values correspond to x- axis value 1
How to insert 2 scales on y-axis? 3
Auto Scale x-axis 1
Changing the Y axis on a column chart 1

Back
Top